Solved

ReplaceRegularExpression syntax


Hi, I am trying to use ReplaceRegularExpression as described here:

http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/!Transformer_Parameters/StringFunctions.htm

To do a simple transformation of Quotes to escaped Quotes in strings.

 

I have the following:

@ReplaceRegularExpression(@Value(Description),["],"\\\\""",FALSE)

(as the instructions say I need to add quotes and escape the quote in the to expression.)

This does not work, but at least does not have errors.

If I try to slightly change the syntax of the to expression (eg less quotes) I get serious errors...

 

Any ideas welcome...

 

 

 

 

icon

Best answer by nielsgerrits 9 May 2022, 08:43

View original

2 replies

Userlevel 5
Badge +31

I tried a bit and

@ReplaceRegularExpression(@Value(Description),\",\\",caseSensitive=TRUE)

seems to work for me. As an alternative you can also use the StringReplacer set to Regular Expression replacing " with \\".

I tried a bit and

@ReplaceRegularExpression(@Value(Description),\",\\",caseSensitive=TRUE)

seems to work for me. As an alternative you can also use the StringReplacer set to Regular Expression replacing " with \\".

Many thanks...that seems to work fine now.....

Reply