What replaced the substring?

trokosz · Post by **trokosz** » Mon Feb 28, 2005 4:43 pm

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

dsxuserrio · Post by **dsxuserrio** » Mon Feb 28, 2005 10:06 pm

It is still there. It is an implicit substring
DSLink3.FIELD_NAME[start,length]

Amos.Rosmarin · Post by **Amos.Rosmarin** » Tue Mar 01, 2005 7:56 am

You can use a modify stage as well using this function:

stringField=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.

Amos