RegEx to clean up data

Question

I have a CSV file with attributedata that's structured kind of like this:

apple man woman 1234-567\\1

apple man woman 1234-567\\1B

apple man woman 1234-567\\12

apple man woman 1234-567 child

890.1234-567

apple A3 1234-567

I'm only interested in the 1234-567 number sequence, since this is an ID I need to match further along. The rest of the attribute data can be deleted. The number sequence seems to always have 4 numbers before the hyphen and 3 numbers after. The hyphen isn't essential and can be removed. The number are the most important

How do I go about it? Do I need a stringreplacer or more than one?

I tried this with stringreplacer, mode= regular expression, text to change set to: (?<!\\\\)\0-9]+

But what do I fill in at replacement text? If I fill in a regular expressions in that field, it returns the regular expression...!

I'm using fme desktop 2019

Page 1 / 1

Easier to use a stringsearcher, and search for the regex. If will then end up in the match attribute

\d{4}\-\d{3}

@fmenco

Stringreplacer is more direct:

regex replace

to search: .*(\\d{4}\\-\\d{3}).*

to replace : \\1

Reply

ebygomm · Accepted Answer

Easiertouseastringsearcher,andsearchfortheregex.Ifwillthenendupinthematchattribute\d{4}\-\d{3}

gio · Answer

@fmenco​Stringreplacer is more direct:regex replaceto search:  .*(\d{4}\-\d{3}).*to replace : \1

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded