I'm needing help with a regex. I need to hit sites at the base of the Post Office, but because of the prepositions many places are not found.
Example:
ARMACAO STREET STREET STREET STREET
Mailbox = STREET BEACH FROM ARMACAO
Outbound file = Public address not found
I need a regex that ignores prepositions and looks for everything before and after it.
I got the expression that returns the prepositions (\ sDE \ sDA \ sDA \ sDO \ s).
ButwhenIputthenegation(?!\sDE\sDA\sDA\sDO\sDO\s),itreturnsnothing.
Do not need to be anything for a specific language, working in text editor is already Ok for what I need. The search of the place will be done by StringReplacer of the FME (image below).