DSXchange

Hi, Yes as Arnd mentioned you have many approach. You can also use CONVERT to convert all the alphabet into 0 or 1 according to your requirement. Hence the left out value will be purely numeric. -Kumar Hi kumar , The input string can have alphanumeric , whitespaces and symbols . Out of this I have ...

the "from_string" functions convert numeric string to decimal/float . String_to_decimal or decimal_from_string function returns me 0.0 on a alphanumeric string. Whereas i want to extract all the numeric characters from a alphanumeric string. Eg: string-> 123fre233 should return me 123 {num...

Hi is there any built-in function to read only the numeric characters of a string

How should i read the following 3 byte value in a single field.The expected value is 000030 value hex{00 00 30} - binary data I tried using decimal packed option but its giving me an error. Now if I append a byte hex{0f} at the end , then read it using decimal pack len- 7 its working ... but i dont ...

Your problem will be solved using the Iconv and Oconv functions. Explore these functions in the Datastage Help file. One of the options in the functions is used for retaining or deleting the alphanumeric characters from the input string. I am unable to tell you the exact syntax , as my PC don't have...