how to get substring from string

ketanshah123 · Post by **ketanshah123** » Mon Aug 06, 2007 5:32 am

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?

JoshGeorge · Post by **JoshGeorge** » Mon Aug 06, 2007 6:17 am

InputString[StartPosition,NumberOfChar]

Maveric · Post by **Maveric** » Mon Aug 06, 2007 6:17 am

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

chulett · Post by **chulett** » Mon Aug 06, 2007 6:22 am

In other words, the exact same function.

bkumar103 · Post by **bkumar103** » Mon Aug 06, 2007 6:44 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 06, 2007 2:28 pm

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.