[RBASE-L] - Re: removing numbers from a string

[Chuck Lockwood]

select (srpl((format(columnName,'||||||||||||||||||||')), ' ','',0)) from TableName   Works with Oterro 3.0 at least.   Chuck Lockwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ LockData Technologies, Inc.                  309 Main Avenue, Hawley, Pa 18428          570-226-7340 ~ Fax: 570-226-7341    [EMAIL PROTECTED] ~ www.lockdata.com                   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~   From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Alan Wolfe Sent: Thursday, August 11, 2005 1:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: removing numbers from a string   ooo nice idea Alastair, thanks I think that's what i'm going to do (: ----- Original Message ----- From: Alastair Burr To: RBASE-L Mailing List Sent: Thursday, August 11, 2005 10:13 AM Subject: [RBASE-L] - Re: removing numbers from a string   Alan,   You could try embedding all 10 numbers into a mammoth SRPL - you might have to use a small name for the variables to keep below the command length limit... or Use a loop with SRPL to go throw the 10 numbers...   Remember with SRPL you can now replace something with nothing - a great enhancement!   Regards, Alastair.   ----- Original Message ----- From: Alan Wolfe To: RBASE-L Mailing List Sent: Thursday, August 11, 2005 5:36 PM Subject: [RBASE-L] - removing numbers from a string   Hey everyone,   Is there a way to remove all numbers from a text string?   IE if i have a string like "34hello65748world" stored in a column I'm trying to get "helloworld".   is there a way to do that in a select statement?   Thank you! Alan