Problem with trimming the filed value

sshettar · Post by **sshettar** » Tue Dec 05, 2006 1:51 pm

Hi All,

Well i have an issue here with the trim function.
i have this filed which looks like this 000000000205935. This field is actually the record count fo the file and it is of length 15 . well now i want to get only the actualy record count as in i need to get rid of the zero's which are at the first . well this can be done by doin the usual trim and left function but i need something in general as the record count may vary . that i need the function to pick the actual count after neglecting all zeros ahead of it .

could someone help me with this?

ArndW · Post by **ArndW** » Tue Dec 05, 2006 1:53 pm

Add 0 to it in a transform stage or TRIM(Column,"0","L")

I_Server_Whale · Post by **I_Server_Whale** » Tue Dec 05, 2006 1:55 pm

If I understood it right. Trim will achieve what your are looking for.

Code: Select all


Trim(In.Column, "0", "L")

I_Server_Whale · Post by **I_Server_Whale** » Tue Dec 05, 2006 1:56 pm

Oh!! My slow fingers. Arnd beat me

narasimha · Post by **narasimha** » Tue Dec 05, 2006 1:56 pm

Another option

Code: Select all

fmt(In.Column, "Z")

DSguru2B · Post by **DSguru2B** » Tue Dec 05, 2006 1:57 pm

Mulitpy it by 1 to get an implict conversion to integer.

sshettar · Post by **sshettar** » Tue Dec 05, 2006 1:57 pm

Thanks guys. it worked

ray.wurlod · Post by **ray.wurlod** » Tue Dec 05, 2006 7:16 pm

Of all the answers given, adding zero requires the fewest CPU cycles and is therefore the most efficient.

Both arithmetic solutions (add zero, multiply by one) rely on the fact that DataStage BASIC always returns the shortest possible character string as its arithmetic result - leading and trailing redundant zeroes are removed.

sb_akarmarkar · Post by **sb_akarmarkar** » Thu Dec 07, 2006 5:24 am

This too... Int(ColumnName)

Thanks,
Anupam