John, You could also use : (SKEEPI(upc_txt,'0123456789')) Jim Bentley
American Celiac Society [email protected] tel: 1-504-737-3293 --- On Wed, 2/11/09, Bill Downall <[email protected]> wrote: From: Bill Downall <[email protected]> Subject: [RBASE-L] - Re: Stripping spaces from a text string To: "RBASE-L Mailing List" <[email protected]> Date: Wednesday, February 11, 2009, 2:16 PM John, NULL works fine as a parameter in SRPL:: (SRPL(upc_txt,' ',NULL,0)) Bill On Wed, Feb 11, 2009 at 3:03 PM, John Engwer <[email protected]> wrote: 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. John Engwer Engwer & Associates 2449 Scenic Ridge Drive North Huntingdon, PA 15642-2120 Phone: 412 751-2433 Email: [email protected] WWW.ENGWER.US
