Skip to main content
  • Home
  • Community
  • Ask the Community
  • General Q&A
  • 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?
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?

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


Terms & ConditionsCookie settings