Page 1 of 1

String as delimiter in Field Function

Posted: Tue Jan 15, 2013 9:02 am
by srinivas.nettalam
Hi ,
Can't we pass a string like 'abc' as delimiter for field function in Server job?
I was using the same function in parallel job with a string as delimiter.The result was as expected.I got a situation to change that job to server job to use UserStatus feature.The output is different from the one coming in a parallel job.

Code: Select all

Output from Parallel job : Field(Field('<usr><sTransType>ABCDEFG</sTransType>','<sTransType>',2),'</sTransType>',1)  = ABCDEFG

From Server job :  Field(Field('<usr><sTransType>ABCDEFG</sTransType>','<sTransType>',2),'</sTransType>',1) =  usr>

Posted: Tue Jan 15, 2013 9:16 am
by chulett
No, not that I recall. And the Server docs mention that the delimiter is the character that delimits the field.

Posted: Tue Jan 15, 2013 9:28 am
by srinivas.nettalam
Thanks Craig.I will try with combination of Index and substring or introduce ereplace first and then apply field.

Posted: Tue Jan 15, 2013 10:38 am
by chulett
Those would be typical approaches in the Server world.