truncate trailing zeroes

[edward_m]

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

[rasi]

Simple answer is to divide your number by 100

Ans = Int(Input_Value/100)

eg. 1. 348500/100 = 3485
2. 87912/100 = 879

[edward_m]

Simple answer is to divide your number by 100

Ans = Int(Input_Value/100)

eg. 1. 348500/100 = 3485
2. 87912/100 = 879

Thanks for your quick reply.My column col2 is varchar datatype.
Please guide me ..

[rafidwh]

Try this

Oconv(columnname, " MR2 " )

I hope U will get

[rasi]

use this Input_Value[1,Len(Trim(Input_Value))-2]

This will give you the result

[Sunshine2323]

Hi Edward,

Substrings(Source.Col,1, Len(Source.Col)-2)

Left(Source.Col,Len(Source.Col)-2)

I am sure there are many more ways of achieving the result.

[raj_konig]

even a direct substring function will get this.

substring(col2, 1,4)

raj

[I_Server_Whale]

Much more simpler would be:

Your derivation becomes:

Code: Select all

col2[1,4]

[edward_m]

Thanks a lot for all.

[ray.wurlod]

There are no actual data types within server jobs. Dividing by 100 was a perfectly valid method. So is substring (or Left() function).