Use one or a series of "SRPL", like this:
UPDATE table SET phone = (SRPL(phone, '(', '', 0))
The second criteria is two quotes together with no space between. You could
use that with the hyphens also. But if you're doing this in 6.5, I can't
remember if 6.5 allowed you to do the two quotes to remove data, I think this
was added in a later version
If not, you might have to write a cursor thru each row and extract each chunk
using SGET
Karen
On Tuesday, February 18, 2025 at 02:50:17 PM CST, Tom Hart
<[email protected]> wrote:
My database is over 20 years old and I finally retired so I'm updating my of
database. When I originally put in phone numbers I put in as (123)-123-1234,
then at some point later on I found format mask. I now want to correct all my
phone numbers to just a string 1231231234. What would be the easiest way to
accomplish this?
Tom Hart
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/CABX9BNeEX33VSjW-4L2G6nvget5PHrfteLpq0g8C1%3Dm%3DL%3DY7BQ%40mail.gmail.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1111783164.1466617.1739915269303%40mail.yahoo.com.
