Hey everyone.I need a formula (regex) that will find all the names that appear in this format.
Bob Alan Smith 17522691 AU
John Smith 13798229 UK
Jade Shaw 54654645345345 AR
Chriss Jaw 234322 AL
Any ideas?
And to complete the trio here is the one using the RegEx tool. 😄The tool showing how t extract data, the second just to check if it match.
I was looking for 3 starting surname/name and 1 was optionnal.
Let's leanr RegEx !! 🙂
hi @soncoku I managed this with the formula:^(.+?)\d
This takes all the values before the first number in the field.
I then split the result by space, but obviously this step is only necessary if you need to do soPlease find attached my workflow, hope this helped!
Hello @soncoku,
Here is a way of doing it.
Hi @soncoku
Are you trying to pull the name part out, or find all strings with the pattern of text followed by a number followed by a two letter code in capital letters?
You can use a RegEx Match function inside a filter tool. If the pattern below represents the whole string, then those that match the pattern will come out on the T, and the rest on the F.
Is there more in each line in your data than what you've highlighted?
Cheers!
Esther
@estherb47
@TheOC
@StephaneP
I apologize. I think I did a terrible job at explaining the problem.So I have a list that has about 20k names
Most of the names are in the format :
FName + LName
Fname + Middle name + Lname
Fname + Lname + digits (about 8-10 digist or more)
Now in this list, I am only interested to find which names are of this format :Bob Alan Smith 14679952 AL
or
Bob Smith 13479786 UKSo I ONLY want the names that have DIGITS after the name and 2 letter country code UK
Name digits Country Code = Bob Smith 14679753 UK
