numeric value to trimed

[snt_ds]

Hi,

I have a numeric column in the backend.
values for this looks like below :
00000123
00000456
00000789
in datastage I need to trim to look like below:
123
456
789
can some please let me know if there is function.

Thanks
Ram

[I_Server_Whale]

Try

Code: Select all

Trim(InCol, '0', 'L')

It certainly works in Server Edition. Not sure about parallel/DSEE.

[karrisuresh]

Hi In the transformer u can use the string function called ltrim and apply that on this column may solve ur problem
pls ack me

Hi,

I have a numeric column in the backend.
values for this looks like below :
00000123
00000456
00000789
in datastage I need to trim to look like below:
123
456
789
can some please let me know if there is function.

Thanks
Ram

[karrisuresh]

Hi In the transformer u can use the string function called ltrim and apply that on this column may solve ur problem
pls ack me

Hi,

I have a numeric column in the backend.
values for this looks like below :
00000123
00000456
00000789
in datastage I need to trim to look like below:
123
456
789
can some please let me know if there is function.

Thanks
Ram

[ray.wurlod]

What is the data type?

The Data Browser always displays Decimal and Numeric data with leading zeroes, so it may be that the source data do not even have leading zeroes; what you are describing may simply be an artifact of using View Data. And nothing you do except changing the data type to string will affect this.

The leading zeroes are irrelevant, and will load happily into any database target if the column is a numeric data type. If the target is a text file, convert to string (VarChar) and trim the leading zeroes. Do not use Char, as this will be padded with trailing APT_STRING_PADCHAR characters.

[I_Server_Whale]

Hi In the transformer u can use the string function called ltrim and apply that on this column may solve ur problem
pls ack me

I'm using version 7.5x2 and ltrim() was not found in the string functions list.

Whale.

[ray.wurlod]

That's because there's no such intrinsic function. Which is not to say karrisuresh has not written one - if so, why not share it?

[DSguru2B]

Change the target metadata to Integer. That should take care of it.