Start a new topic

Regular Expression - Extract text based on specific characters


Very new to IOM and already ran across a complicated scenario. 

we receive the following gift information information from a website:  

John  Doe--FSP1341-Fake Film Title

I need to extract just FSP1341 .  The last four digits can vary but FSP is always the same. 

Any help on this would be greatly appreciated!

1 Comment

You can make a dictionary to do this.

Replacement Value: $1
Value to match: .*--(.*)-.*
Check "Use Regular Expressions"

Then apply that dictionary to your input field and you should get just what is between the dashes.
Login or Signup to post a comment