Deleting trailing Zeroes

[Anonymous]

Hi all,

I am importing a data from CSV file and in 1 field it contains additional Zeroes.

How I can remove the last 2 zeroes from this field.

Example:

Field		Output required
1M00		1M
1N00		1N
2B00		2B
2G00		2G
2N00		2N
2Q00		2Q
3000		30
3Y00		3Y
4H00		4H
4X00		4X
5M00		5M
5U00		5U
5X00		5X
6400		64
6A00		6A
6J00		6J
6U00		6U
7F00		7F
7T00		7T
8A00		8A
8J00		8J
8N00		8N
8W00		8W
9C00		9C
9F00		9F

Regards

Abhijit

[sunny_talwar · Accepted solution]

May be just this

Left(Field, 2) as ReqOutput

or this

Left(Field, Len(Field)-2) as ReqOutput

[shiveshsingh]

Try

left(Field,2) as Field while loading

[sasiparupudi1]

May be Like this?

Load

Field,

If(IsNum(Field),Field/100, SubField(Field,'00',1)) as NewField

Resident YourTable;

[Anonymous]

After posting I followed the same approach.

Thanks it worked