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
Drop last character in astring
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Drop last character in astring
Thanks,
Vinay
Vinay
Code: Select all
LEFT(in.col, (LEN(in.col)-1)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am