When i am writing a numeric field the data is preceded with blank and the actual value
eg:actual value1000.00 and data showing in the file as ' 1000.00'. there is a blank infront of 1 and im not able to trim this.
how to handle this?
Thanks
sri
Writing to Fixed width file
Moderators: chulett, rschirm, roy
Writing to Fixed width file
Last edited by parsi_cnu on Mon Apr 28, 2008 8:28 pm, edited 1 time in total.
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
trim(col_name,' ','A')
trim(col_name,' ','A')
try this
try this
Actually i am calculating field in the transformer
actually i am dividing numeric column/10
source numeric column(length 7)/10 and target numeric column of length 6,2
source numeric column(length 7)/10 and target numeric column of length 6,2
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Len(Trim(numeric_col))
How can we do?
thanks
sr
thanks
sr