DSXchange

hi
how to get the substring from string in DS PX?
there is substrings function in server jobs,is there any such function in parallel job?

InputString[StartPosition,NumberOfChar]

Yes. FieldName[3,5]. ie from 3rd field take 5 characters. for an input "Anexample" will return "examp"

In other words, the exact same function.

There is no direct function available in the parallel jobs. You have to make use of Right and left function. Like for example for the string "Hello" if we want to get the substring "ell" then left(right("Hello",4),3) and like this.

Despite bkumar103's confident assertion there IS a direct operation available in parallel jobs. In the Transformer stage use the square bracket notation mentioned by earlier posters. In the Modify stage use the substring() function, noting that character position is a zero-based number - that is, the first character in the string is position 0.