Numeric part extraction

karry450 · Post by **karry450** » Wed Jan 06, 2010 11:38 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 07, 2010 2:57 am

Use the DIGITS Transform. This is precisely what it does.

karry450 · Post by **karry450** » Thu Jan 07, 2010 3:08 am

ray.wurlod wrote:Use the DIGITS Transform. This is precisely what it does. ...

Hi Ray Can please elobarate on this.

karry450 · Post by **karry450** » Thu Jan 07, 2010 3:13 am

And also can you please help me if I want get only the alphabets out of the string

karry450 · Post by **karry450** » Thu Jan 07, 2010 3:21 am

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

chulett · Post by **chulett** » Thu Jan 07, 2010 7:02 am

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.