Results 1 to 4 of 4

Thread: Need help!

  1. #1
    Join Date
    Nov 2012
    Posts
    20

    Unanswered: Need help!

    Hi there,

    I am trying to write script which will allow me to replace a value of specific character in my case (replace comma "," with space " ") in the address field. I was able to replace the entire value within the field with something else but couldn't figure out how to replace only one character within a field (in this case replace comma with space).

    I would really appreciate your help on this.

    Thanks!

  2. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    See attached file.
    All "," will be replaced by a space when you press Enter or click anywhere.

    If you only want the script to change the fist comma and not all of them, edit the script. Change REMP to REMO.

    Regards
    James
    Attached Files Attached Files

  3. #3
    Join Date
    Nov 2012
    Posts
    20
    Hi James,

    Thank you so much for uploading the file. I will give it a try.

    Your support is really appreciated.

  4. #4
    Join Date
    Nov 2012
    Posts
    20
    Worked perfectly.

    Thanks!

Posting Permissions

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