Skip to main content
  • EN

I have an identifier attribute which can take different forms.

All contain a number, like 985 or B985 or 985a

Some are preceded by a capital letter like B985

Some are followed by a smallcaps letter or the character "*" like 985b or 985*

 

I want

  • the capital letters at the beginning of the string to go into attribute PREFIX
  • the numeric to go into attribute NUMBER
  • the smallcaps letter or the * to go into attribute SUFFIX

 

I imagine using regex is the way. I have got the job partly done with a series of StringSearchers but I'd like to have advice from someone with experience.

 

Thanks in advance !

 

 

@tim_bkr​  You're probably on the right path with a regular expression in StringSearcher. Something like:

(:a-zA-Z]{0,1})(>0-9]+)(Za-zA-Z\*]{0,1})

Go to regexr.com to learn how that expression works.

The trick is on the StringSearch under Advanced use the Subexpression Matches List Name:

dialogI've attached an example workspace (FME2021.0).

       

Waw, brilliant !

Thanks a ton !

Reply


Community Stats

30,177
Posts
114,556
Replies
37,844
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.