Skip to main content
Solved

How to Change multiple substrings at one with StringReplacer?

M

I'm new to FME so sorry for a noob question.

I have a text file that is in the below format. How can I replace the characters with an index of 15:15, 25:25, and 30:30 with just the '|' character (pipe)? There are only spaces in now. I have been trying to use StringReplacer and set the "Text to match" with @substring ( , 15, 15) but it doesn't work. Do I have to do each replace with it's own transformer or is it possible I can also do this with one StringReplacer?

Thank you in advance!

Characters 1:1415:15Characters 16:2425:25Characters 26:2930:30Character 31:31XXXXXXXXXXXXXX

 

XXXXXXXXX

 

XXXXX

XXXXXXXXXXXXXX

XXXXXXXXX

XXXX

X

 

Best answer by jdh

I am assuming that the characters in the other indices contain spaces, so you can't just use a stringReplacer with space and pipe.

 

You can build a new attribute with the text editor @Substring(@Value(attr),0,14)|@Substring(@Value(attr),15,9)|@Substring(@Value(attr),25,4)|@Substring(@Value(attr),30,1)

 

 

where attr is the attribute containing the original string.

 

 

Note: Substring in the text editor work with the starting index (begining at 0) and number of characters to extract, not ending index like the SubStringExtractor transformer.
View original
Did this help you find an answer to your question?

4 replies

jdh
Contributor
Forum|alt.badge.img+28
  • jdhContributor
  • Contributor
  • Best Answer
  • April 4, 2017

I am assuming that the characters in the other indices contain spaces, so you can't just use a stringReplacer with space and pipe.

 

You can build a new attribute with the text editor @Substring(@Value(attr),0,14)|@Substring(@Value(attr),15,9)|@Substring(@Value(attr),25,4)|@Substring(@Value(attr),30,1)

 

 

where attr is the attribute containing the original string.

 

 

Note: Substring in the text editor work with the starting index (begining at 0) and number of characters to extract, not ending index like the SubStringExtractor transformer.
takashi
Influencer
  • takashiInfluencer
  • April 4, 2017

Agree. To add to @jdh's answer, you have to be case sensitive for the function name. @substring won't work, @Substring is correct.

Alternatively, you can still use the StringRepalcer with 'replace regular expression' mode.

  • Text to Match: ^(.{14}).(.{9}).(.{4}).(.)$
  • Replacement Text: \\1|\\2|\\3|\\4
  • Use Regular Expressions: yes
M
  • mwilchek
  • Author
  • April 5, 2017

Awesome, thank you so much!! Really appreciate it!

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • April 7, 2017

@mwilchek

That would make you having count your strings. Lucky for you it isn't like a 10000 long or so.

Do away whit that!

Use in stringreplacer, regexp mode.

text to match :

(?:(\\d+:\\d+)) (\\d+):\\2

text to replace:

\\1|

Clearly more elegant.. ;)

Reply


Helpful Members This Week

Community Stats

31,223
Posts
118,404
Replies
38,824
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.