replaceAll not working as expected
Hi,
I have a variable
FooBar: this is first line
this is second line
this is thrird line
@String.replaceAll(.FooBar,"\r\n"," ")
I expect output: this is first line this is second line this is thrird line
but still get
this is first line
this is second line
this is thrird line
Appreciate any clues why is this behaving this way. Thanks in advance.
Background: upgraded from 6.2 to 7.1.9
***Updated by moderator: Vidyaranjan | Included Categories
Couple of questions
1) How did you confirm the order of the line break and carriage return characters \r\n or \n\r?
2) Are you sure that both characters are present? Might be a good idea to write a quick test to confirm this, as the regex search will not match your search criteria if only one character is present.
Regards
Patrick
Hi I confirmed as described above. And yes both character as present. It used to work in 6.2 but not in 7.1.9.
Can I alternatively provide "\r|\n|\r\n|\n\r"?
So replaceAll is not handling normalization of a string that why it is failing.
HI Afzal,
Instead of using replaceAll , Could you please try with pxReplaceAllViaRegex function which handles the regular expressions. replaceall will not handle the regular expressions.
HI Rajendraprasadu,
I just saw your note, actually did endup using pxReplaceAllViaRegex. Thanks
Couple of questions
1) How did you confirm the order of the line break and carriage return characters \r\n or \n\r?
2) Are you sure that both characters are present? Might be a good idea to write a quick test to confirm this, as the regex search will not match your search criteria if only one character is present.
Regards
Patrick