String as delimiter in Field Function

srinivas.nettalam · Post by **srinivas.nettalam** » Tue Jan 15, 2013 9:02 am

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>

chulett · Post by **chulett** » Tue Jan 15, 2013 9:16 am

No, not that I recall. And the Server docs mention that the delimiter is the character that delimits the field.

srinivas.nettalam · Post by **srinivas.nettalam** » Tue Jan 15, 2013 9:28 am

Thanks Craig.I will try with combination of Index and substring or introduce ereplace first and then apply field.

chulett · Post by **chulett** » Tue Jan 15, 2013 10:38 am

Those would be typical approaches in the Server world.