REPLACE is good news

  • This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
Jan 30, 2010
21
0
#1
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.