Try this. I suppose it could be incorporated into a stored procedure. Also, it leaves blanks (ASCII 32) in place of the numeric-characters, but I'm sure this little routine could be adapted/extended to deal with this.
HTH, Steve in Memphis -- ******************************************************** -- *** SRPL_Numbers.CMD *********************************** -- *** 2005.08.11, JSW ************************************ -- *** To replace all characters in a string -- *** that can successfully be cast as NUM (0,1,2,3...9) -- ******************************************************** CLS SET VAR vStringA TEXT="34hello65748world" SET VAR vStringB TEXT=.vStringA SET VAR vNUMCounter INT=0 WHILE vNUMCounter < 10 THEN SET VAR vStringB=(SRPL(.vStringB,CTXT(.vNUMCounter)," ",0)) SET VAR vWriteRow INT =(.vNUMCounter + 1) WRITE "Removing ",.vNUMCounter,"'s from ",.vStringA," resulting in ",.vStringB AT &vWriteRow,10 SET VAR vNUMCounter=(.vNUMCounter + 1) ENDWHILE NORMALIZE RETURN -- ******************************************************** ----- Original Message ----- From: Alan Wolfe To: RBASE-L Mailing List Sent: Thursday, August 11, 2005 11:36 AM 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 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
