while using replace function in celonis pql getting an error because string contains a comma in the value and replace function is considering it as a parameter in the function. is there a work around for it?
Page 1 / 1
Hi,
maybe you should provide more information or an example to made it easier to understand your situation.
When using a string like 'AB,C' containing a comma I do not get any issues with PQL:
e.g REPLACE ( 'AB,C', 'AB,' , 'B' )
BR
Dennis
Can someone help me understand what is wrong with my code here?
FILTER "_CEL_O2C_ACTIVITIES"."USER_NAME" = 'BATCH_JOB';
REPLACE ( "_CEL_O2C_ACTIVITIES"."USER_NAME" , 'BATCH_JOB' , 'AUTOMATED' );
on the second line with replace its throwing an error because it says: "Expected "REGISTER" "TABLE" "DOMAIN" ... etc." Im really not sure what this means because my query starts with a filter command.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.