Manipulating Text Strings

Results 1 to 3 of 3

Thread: Manipulating Text Strings

  1. #1
    Join Date
    Dec 1969

    Default Manipulating Text Strings

    Hi,<BR><BR>Is it possible to take a text string and search for any, lets say commas, and then check if a space exists after the comma, if so remove it and do this right the way along the text string. (There must be functions that can do this)<BR><BR>For Example if I have this string:<BR>"Hello, Nice day today, isn&#039;t it?"<BR><BR>It can become:<BR>"Hello,Nice day today,isn&#039;t it?"<BR><BR>Any help would be greatly appreciated.<BR><BR>Jarvis

  2. #2
    Join Date
    Dec 1969

    Default RE: Manipulating Text Strings

    Replace(string, ", ", ",")

  3. #3
    rhopper Guest

    Default RE: Manipulating Text Strings

    Try the Replace function. The following should take any commas followed by a space and replace them with just commas. "oldstring" and "newstring" are variables for the original text and the modified text.<BR><BR>&#060;%<BR><BR> newstring = Replace(oldstring, ", ", ",")<BR>%&#062;<BR><BR>Good luck!

Posting Permissions

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