Thanks Karen and Bill,
That is a good work around. John From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, February 11, 2009 3:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Stripping spaces from a text string You can use SRPL. The first set of quotes has one space between, the second set of quotes have no space between (SRPL( upc_txt, ' ', '', 0)) Karen I have a text column that has numbers with spaces interleaved (example 8 1234 5678 9). I am trying to strip the spaces so that I end up with the following 8123456789 (all of the numbers without spaces). I tried to accomplish this by using the following function: Update FINN set UPC_TXT = (sstrip(upc_txt,(char(032)))) I have also tried: Update FINN set UPC_TXT = (sstrip(upc_txt,’ ‘)) This does not work either: set var vTEST text = (sstrip('8 1234 5678 9',(char(032))))… the result is 8 1234 5678 9 Any ideas what I am doing wrong.
