1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

REPLACE is good news

Discussion in 'Support' started by bravotango, Feb 6, 2010.

  1. bravotango

    Joined:
    Jan 30, 2010
    Messages:
    21
    Likes Received:
    0
    I had a need to get rid of long strings of spaces in a large database and replace them with a comma so I was trying to figure a way to get perl to do the job but for some reason perl would not work in the editor although it does work in TCC.
    Then I saw a post in the forum about @REPLACE and it really works.
    set cc=%@replace[^ ,^,,%cc]
    Only thing I found I had to keep those commas really tight otherwise extra spaces appear.
    There is probably a nicer way to get rid of nineteen unwanted spaces but this will do for now. Extra spaces not shown in example for brevity.
     

Share This Page