|
Emmitt - I totally missed (ISALPHA()) - I like your solution
better than mine ...
Cool enuf,
Steve in Memphis
----- Original Message -----
Sent: Thursday, August 11, 2005 12:16
PM
Subject: [RBASE-L] - Re: removing numbers
from a string
Alan,
You could start by using (SLEN()) to get the
length of the string, then within a while loop looking for that many
iterations, test each character in turn by using (SGET()) to extract the
character, test it using (ISALPHA()), then, if it is alpha, append it to a
result string. I'm sure you could even find ways to nest some of those
functions.
Need more?
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
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge
Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203)
673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
|
