Skip to main content
Solved

Question about StringReplacer


plynn
Participant
Forum|alt.badge.img+3
  • Participant

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.

Best answer by geomancer

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

View original
Did this help you find an answer to your question?

2 replies

geomancer
Evangelist
Forum|alt.badge.img+47
  • Evangelist
  • Best Answer
  • August 5, 2021

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


plynn
Participant
Forum|alt.badge.img+3
  • Author
  • Participant
  • August 5, 2021
geomancer wrote:

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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings