How to normalize house numbers using Regular Expression?

Hello FME masters,

I have a set of housenumbers I'd like to update. I'm trying RegEx but not getting the result I want.

What it boils down to:

HaveWant1-A1A22-2422

First example: I'd like to clean out the dashes but keep the letter following the dash.

Second example: Clean out the dash and any digits following it.

How can I do this in the StringReplacer?

Thanks,

Ed

Page 1 / 1

Hello Ed,

You can use the expression below and replace with nothing.

(?<=\d)\-\d*

Hello Ed,

You can use the expression below and replace with nothing.

(?<=\d)\-\d*

Hi @denizturan1985,

Thanks! - that tHERE did the trick nicely. ;-)

Cheers,

Ed

Sign up