FPL Replace Pipe

[priyank]

Hi All,

I am using FPL to replace all "|" (pipe) symbols in one of my script with "," (comma).

However, the result of using replace(String, "|", ",") or replace (String, "\|", ",") isn't what I am expecting.

Please help me to get over this tiny issue.

Thanks.

[Jon]

Priyank,

It seems to work OK like this:

replace(mystring, '[\|]', ',');

i.e. with [] around the escaped pipe symbol.

Regards
Jon

[priyank]

Thank you for the reply Jon. That works perfectly!