Skip to main content

I am needing to read a comments field and replace the double quotes with 'inches' and replace & with 'and'. I tried my hand with regular expressions, but am very new to this and it did not work (user error I am sure). I also just tried Replace Text and it doesn't seem to work either.

StringReplacer works all right for me, see the attached workspace (FME 2020.1). It replaces " with <space>inches, and & with and.

I've also tried StringPairReplacer, in this transformer some special characters (like " and space) need to be escaped with \\.

StringReplacer_inch_ampersant


StringReplacer works all right for me, see the attached workspace (FME 2020.1). It replaces " with <space>inches, and & with and.

I've also tried StringPairReplacer, in this transformer some special characters (like " and space) need to be escaped with \\.

StringReplacer_inch_ampersant

Excellent. Thank you!


Reply