Solved

Question about StringReplacer

  • 5 August 2021
  • 2 replies
  • 16 views

Badge +1

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.

icon

Best answer by geomancer 5 August 2021, 14:47

View original

2 replies

Userlevel 4
Badge +36

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

Badge +1

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