How can we convert Numeric to VarChar in DataStage?
Please help!!
Thanks, Raj
Numeric to String conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Fri May 14, 2010 3:54 pm
Numeric to String conversion
Rajesekhar Potteti
-
- Participant
- Posts: 19
- Joined: Fri May 14, 2010 3:54 pm
I am having a dataset one of the column names is ID whose values are like 000123, 000124 etc.. This is of DataType numeric.
I have a table to which I need to do a lookup using these values.. table has values like 123, 124 etc.. This is of data type VarChar.
So from the above dataset input I need to takeout leading zeros to do a proper lookup and get going.
How can I do that?
I thought of converting numeric to string and strip the leading zeros using Trim function.
Could you suggest me a better way if we have any?
Thanks, Raj.
I have a table to which I need to do a lookup using these values.. table has values like 123, 124 etc.. This is of data type VarChar.
So from the above dataset input I need to takeout leading zeros to do a proper lookup and get going.
How can I do that?
I thought of converting numeric to string and strip the leading zeros using Trim function.
Could you suggest me a better way if we have any?
Thanks, Raj.
Rajesekhar Potteti