Skip to main content
Solved

Using Regular Expression Editor to find number strings between 8 and 14 digits long

  • July 9, 2020
  • 1 reply
  • 1223 views
J
Forum|alt.badge.img

Hi, I need to find and extract numbers from a string of text, numbers and characters (see example below). The conditions needed are that the number string can only be between 8 and 14 digits long.

I'm inexpericed with writing Regex but following some previous guidance from this wonderful FME community I did make a start (see below) however it's not doing exactly what I need it to do.

Initally I thought I had solved this until I realised the data has number strings of between 8 and 14 digits/ I'm using the String Searcher transformer.

My expression seems to be finding strings of 8 (or more) digits but only extracting the first 8 digits. This means that when the number string is greater than 8 it cuts the trailing numbers off (se below).

The data I have been provided with is messy to say the least!

In addition to the above question I'd like to ask if its possible to identify and extract, from results of the above, number strings of 8 digits that start with the digit '23'.

In the example below I'd like the extression to find the entire 11 digit string then find 'within' the string the number '23627372'

 

Any help would be greatly appreciated.

Best answer by ebygomm

(\d{8,14}) 

will match between 8 and 14 numbers

If you know they are always sandwiched between two underscores, i'd probably add in a lookahead and lookbehind too

(?<=\_)\d{8,14}(?=\_)

Once you've matched your longer number, you could extract the last eight digits into a new attribute if they start with 23

0684Q00000ArLGYQA3.png

Alternatively, if it's always the last 8 digits of a possibly longer number you need, you could just use a single regex statement, which would extract the 8 digits that are followed by an underscore

\d{8}(?=\_)
View original
Did this help you find an answer to your question?

1 reply

ebygomm
Influencer
Forum|alt.badge.img+31
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • July 9, 2020
(\d{8,14}) 

will match between 8 and 14 numbers

If you know they are always sandwiched between two underscores, i'd probably add in a lookahead and lookbehind too

(?<=\_)\d{8,14}(?=\_)

Once you've matched your longer number, you could extract the last eight digits into a new attribute if they start with 23

0684Q00000ArLGYQA3.png

Alternatively, if it's always the last 8 digits of a possibly longer number you need, you could just use a single regex statement, which would extract the 8 digits that are followed by an underscore

\d{8}(?=\_)

Reply


Most helpful members this week

Community Stats

30,858
Posts
116,996
Replies
38,689
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.