how to extract numeric data?
Moderators: chulett, rschirm, roy
how to extract numeric data?
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?
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?
-
- Participant
- Posts: 47
- Joined: Mon May 07, 2007 10:35 pm
Re: how to extract numeric data?
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?
FD
Re: how to extract numeric data?
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,
[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.
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.
-
- Participant
- Posts: 23
- Joined: Sat Sep 29, 2007 6:05 am
- Location: Datastage
- Contact:
Extracting Numeric data
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)
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
Re: Extracting Numeric data
muralimcs_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)
As integer is used to convert in to integer data type