Page 1 of 1
Numeric part extraction
Posted: Wed Jan 06, 2010 11:38 pm
by karry450
Hi Friends,
My input data is VARCHAR 255 ( ASFG1J3K88U7) and I want to extract only the numeric numbers from above input as ( 13887) as output of it to target table .
Can anyone help me on this.
Posted: Thu Jan 07, 2010 2:57 am
by ray.wurlod
Use the DIGITS Transform. This is precisely what it does.
Posted: Thu Jan 07, 2010 3:08 am
by karry450
ray.wurlod wrote:Use the DIGITS Transform. This is precisely what it does. ...
Hi Ray Can please elobarate on this.
Posted: Thu Jan 07, 2010 3:13 am
by karry450
And also can you please help me if I want get only the alphabets out of the string
Posted: Thu Jan 07, 2010 3:21 am
by karry450
karry450 wrote:And also can you please help me if I want get only the alphabets out of the string
THANKS Ray I hat got the output
for alphabets I used LETTERS
Posted: Thu Jan 07, 2010 7:02 am
by chulett
Exactly. And if you look at the transform code you'll see they're both just wrappers for the OConv function, something that's easier to remember and self-documenting.
Please mark your post as Resolved using the button at the top of the page.