Results 1 to 5 of 5

Thread: Replace

  1. Aug 17th, 2006, 07:15 PM #1
    Pouncer
    Pouncer is offline

    Thread Starter
    Frenzied Member
    Join Date
    Sep 2005
    Posts
    1,364

    Replace

    do multiple replaces work like:

    Replace(str, ",", "", ".", "")

    which should remove all instances of , and . from str

    would it work?
    Reply With Quote Reply With Quote
  2. Aug 17th, 2006, 07:29 PM #2
    Billy Conner
    Billy Conner is offline
    Hyperactive Member
    Join Date
    Aug 2006
    Location
    TeXaS
    Posts
    497

    Re: Replace

    no you have to do each one seperately

    from msdn help...

    Syntax

    Replace(expression, find, replacewith[, start[, count[, compare]]])
    Reply With Quote Reply With Quote
  3. Aug 17th, 2006, 08:08 PM #3
    Pouncer
    Pouncer is offline

    Thread Starter
    Frenzied Member
    Join Date
    Sep 2005
    Posts
    1,364

    Re: Replace

    how about:

    Replace(Replace(str, ".", ""), ",", "")
    Reply With Quote Reply With Quote
  4. Aug 17th, 2006, 08:10 PM #4
    Comintern
    Comintern is offline
    Fanatic Member Comintern's Avatar
    Join Date
    Nov 2004
    Location
    Lincoln, NE
    Posts
    826

    Re: Replace

    That should work, but it's better practice to use the constant vbNullString instead of the "".
    Check out my CodeBank submissions:

    VB6 - UUE Encoder/Decoder, Base64 Encoder/Decoder, yEnc Encoder/Decoder, Memory Mapped Files, String/File Differences, Count TIF Pages
    Reply With Quote Reply With Quote
  6. Aug 17th, 2006, 08:11 PM #5
    Pouncer
    Pouncer is offline

    Thread Starter
    Frenzied Member
    Join Date
    Sep 2005
    Posts
    1,364

    Re: Replace

    Quote Originally Posted by Comintern
    That should work, but it's better practice to use the constant vbNullString instead of the "".
    Ok. Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width