In server jobs I used the substring function in Transformer but in parallel jobs this function no longer exists. What are good ways to get the substring affect in parallel jobs?
Thanks
What replaced the substring?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 82
- Joined: Thu Dec 02, 2004 10:27 pm
- Location: INDIA
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
You can use a modify stage as well using this function:
AmosstringField=substring [startPosition,len] (stringField)
Converts long strings/ustrings to shorter strings/ustrings by string extraction. The startPosition specifies the starting location of the substring; len specifies the substring length. If startPosition is positive, it specifies the byte offset into the string from the beginning of the string. If startPosition is negative, it specifies the byte offset from the end of the string.