truncate trailing zeroes
Posted: Tue Feb 07, 2006 8:35 pm
My sequential file looks like ..
col1 col2 col3
1 100100 123
2 200000 234
3 199900 245
4 329800 424
5 345000 125
6 234500 235
I want to convert this file to..
col1 col2 col3
1 1001 123
2 2000 234
3 1999 245
4 3298 424
5 3450 125
6 2345 235
i.e i need to supress last two zeroes in col2 and load into target.
I used the trim(col2,"0","T"),its taken out all trailing zeroes..
Please guide me how to takeout last two zeroes from col2.
Thanks
col1 col2 col3
1 100100 123
2 200000 234
3 199900 245
4 329800 424
5 345000 125
6 234500 235
I want to convert this file to..
col1 col2 col3
1 1001 123
2 2000 234
3 1999 245
4 3298 424
5 3450 125
6 2345 235
i.e i need to supress last two zeroes in col2 and load into target.
I used the trim(col2,"0","T"),its taken out all trailing zeroes..
Please guide me how to takeout last two zeroes from col2.
Thanks