String.replace and replaceFirst in BIRT

isl01jbe

Hi All,

I am trying to replace parts of a string. More exactly, I am trying to replace parts of my sql query string using this.queryText = this.queryText.replace("[Bobs your uncle]","Yes he is");

The trouble is that "replace" replaces all occurrences of "[Bobs your uncle]". I only want to remove the first occurrence. In order to do this, I tried using replaceFirst instead. This didn't work as the string is then suddenly interpreted as a regular expression and no match with my string is found.

So, a few alternatives remain:

1. Make replace only replace first occurence
2. Make replaceFirst use string literals instead of interpreting them as regex
3. Escape my string before using replaceFirst.

Any help is appreciated.

Best regards

Jonas

mwilliams

Can you recreate your issue with the sample database, so I can run the report? I tried using replaceFirst and it works without issue.