how to define beginning and end of text

Question

Hi, I would like to know hot to define the texts beginnig and end.

I have got :

Attribute: Adressen_kalkuliert_drop_loc

D-L-143245-143245-F-45--1xMICRO-DUCT-12x10-6MM

D-F-422-F-471--1xMICRO-DUCT-12x10-6MM

(a tousands of them)

and need to define Attribute Value:

L-143245 (from the first one) and

F-422 (from the second one)

the texts are always different, and have a different number of numbers

But beginns alway with "F", or "L" and ends always with "-" behind the number.

thanks

redgeographics · Accepted Answer

You can try a StringSearcher with the regular expression rL|F]-\d+ but on both lines of sample text it will actually match more than just that. If you create a list of matches and grab the first item it will probably be what you want.

For more security, try the regular expression ^D-oL|F]-\d+ and then a StringReplacer afterwards to replace regex ^D- with nothing.

A small correction. tL|F] matches not only L or F but also | (pipe), so this expression would be better.

�LF]-\d+
or
(L|F)-\d+

terezia86 · Answer

You can try a StringSearcher with the regular expression rL|F]-\d+ but on both lines of sample text it will actually match more than just that. If you create a list of matches and grab the first item it will probably be what you want.

For more security, try the regular expression ^D-oL|F]-\d+ and then a StringReplacer afterwards to replace regex ^D- with nothing.

A small correction. tL|F] matches not only L or F but also | (pipe), so this expression would be better.

�LF]-\d+
or
(L|F)-\d+

Reply

Community Stats

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