Page 1 of 1

How to Splite String in PX

Posted: Thu Jan 18, 2007 12:59 pm
by swades
Hello All,
can somebody tell me that How to splite string in PX job?
as i know that substring function in server job,but what about PX?
Ex. input - ABCDEF
output - ABCD and EF

Thanks.

Posted: Thu Jan 18, 2007 1:03 pm
by I_Server_Whale
You can use In.String[1,4] for ABCD and In.String[5,2] for EF.

Posted: Thu Jan 18, 2007 1:15 pm
by DSguru2B
Which btw, is also the same as server.

Posted: Thu Jan 18, 2007 1:34 pm
by swades
DSguru2B wrote:Which btw, is also the same as server.
what btw?

Posted: Thu Jan 18, 2007 1:34 pm
by swades
I_Server_Whale wrote:You can use In.String[1,4] for ABCD and In.String[5,2] for EF.
where i found this function?
reply me thanks.

Posted: Thu Jan 18, 2007 1:42 pm
by DSguru2B
its not a function. just put square brackets" [x,y]" where x is the start point and y is the length.

Posted: Thu Jan 18, 2007 1:57 pm
by swades
DSguru2B wrote:its not a function. just put square brackets" [x,y]" where x is the start point and y is the length.
Actually I tried both way,using Left and Right String Function and also by your methods ,so both working fine.

Thanks.Issue solve.

Posted: Thu Jan 18, 2007 2:15 pm
by kcbland
swades wrote:
DSguru2B wrote:Which btw, is also the same as server.
what btw?
btw means "by the way"

Posted: Thu Jan 18, 2007 2:19 pm
by DSguru2B
Thanks Ken :wink: .