I have a requirement to pass the source data which may contain some text characters (like quotes), to the target column removing them.I mean i need only the numeric characters in my target. Source is of data type Decimal and target datatype is varchar.
For example:-
Eg1:-
ToNumber("123.45")
Should return=123.45
Eg2:-
ToNumber({file.REFERENCE})
Should Return 200.00 where "200" is the text string in the file.REFERENCE} field.
I believe, in server jobs we can specify by....
Conversion Expression Internal Value
X = Iconv("John Smith 1-234", "MCN") X = "1234"
But as i am in parallel jobs i cannot use those Oconv and Iconv functions..So, how can i solve this....
Can anyone share your ideas...
![Idea :idea:](./images/smilies/icon_idea.gif)
![Razz :P](./images/smilies/icon_razz.gif)