Drop last character in astring

[vinaymanchinila]

Hi,
I have a source col and I need to drop the last character off it , here is what I tried to do


Stage Variable: Len1=Len(Src.Col1)

Output=Src.col1[1,Len1]

Apparently I cannot use the Stage variable , is there any other way I can do it.

Src=abcdef
Required Tgt=abcde

The source length is varying and not fixed.

Thanks

[DSguru2B]

Code: Select all

LEFT(in.col, (LEN(in.col)-1)

And with your code, you need to provide LEN(in.col) - 1 for stage variable LEN1. It will work

[vinaymanchinila]

Thanks it works