DSXchange

Hi
In transformer i am having one input column as varchar. in that field i have to extract the numeric digits from the input data.please let me know if any functions available for that?

What type of input is it exactly? It will be easier if you can post some sample data. Is it a mix of char & numerics?

kishore2456 wrote:What type of input is it exactly? It will be easier if you can post some sample data. Is it a mix of char & numerics?

Actually input field is varchar (10) and it contains julian date... now it have only numeric values.
ex: 35064,35884,1,

If it is only "," then you can use the trim function. Not sure of the options but i think 'A' removes all occurences.

Trim(In.Col,',','A')

[quote="Maveric"]If it is only "," then you can use the trim function. Not sure of the options but i think 'A' removes all occurences.

Trim(In.Col,',','A')[/quote

hi

In my sample data 35064,35884,1.. here 35064 is coming in a row and viz versa. i hope you meant all in a single row. it has not like that. i mentioned my ip column scale is 10 only. i hope trim and field functions are not correct options.

Your requirement is not clear.

Give sample input data and sample output data.

You had mentioned

ex: 35064,35884,1,

Do you have three columns in your input?

Hai,

One of u r column contains the varchar as its datatype. But you want to extract the numeric values.

There is an option in transformer stage, goto functions----->
As integer(columnname)

mcs_murali83 wrote:Hai,

One of u r column contains the varchar as its datatype. But you want to extract the numeric values.

There is an option in transformer stage, goto functions----->
As integer(columnname)

murali
As integer is used to convert in to integer data type

As said,Requirement is not clear!
since you said you need to do something in transformer,Trim could be the best choice.check the guide it has lot of options.

Edi