how to eliminate left & right side zero's

[ds_dwh]

my i/p like this
column
001
102
1300
00102

required o/p like this
column
1
102
13
102

how to achive this one

[antonyraj.deva]

TRIML and TRIMT functions in a transformer with "0" specified as the character to be removed.

--Tony

[ray.wurlod]

What are your data types?

Trim() function has options to strip from either or both sides.

Convert() would not be appropriate because it would also take out embedded zeroes.

[ray.wurlod]

TRIML and TRIMT functions in a transformer with "0" specified as the character to be removed.

--Tony

These functions do not exist in the Transformer stage.

[antonyraj.deva]

These functions do not exist in the Transformer stage.

Sorry Ray...was little confused

[agpt]

my i/p like this
column
001
102
1300
00102

required o/p like this
column
1
102
13
102

how to achive this one

make two stage variables

first would remove leading zeros and second trailing:

stage1 = trim(input,"0","L")
stage2 = trim(stage1,"0","R")

Here stage 2 is going to be your output variable.

[priyadarshikunal]

make two stage variables

first would remove leading zeros and second trailing:

stage1 = trim(input,"0","L")
stage2 = trim(stage1,"0","R")

Here stage 2 is going to be your output variable.

You don't need 2 fuctions to do that, just use trim with option 'B'.

[agpt]

make two stage variables

first would remove leading zeros and second trailing:

stage1 = trim(input,"0","L")
stage2 = trim(stage1,"0","R")

Here stage 2 is going to be your output variable.

You don't need 2 fuctions to do that, just use trim with option 'B'.

true thanks Priya.....