If I have
SAMSUNG S21+ 128GB
my current regex parse is, (\w+\s+\w+)
How can I make it so I include the "+" so I get SAMSUNG S21+? Currently I get just Samsung S21
Cheers!
Hi @hudg16 ,
aaaaaaaand another way:
(^.*?\s.*?[\w+]+)
Regex is my friend.
M.
@hudg16 How about this one?
Hi @hudg16
Here is another way to do it.
Workflow:
.+ checks any character set including + and the pattern it checks is
(.+(character set)\s(spaces)+.+(character set))\s
Hope this helps 🙂
Thanks everyone, went with mceleavey as it seemed friendliest to some other formatting that could pop up.!
@hudg16 ,
Don't do it!!!
@mceleavey and his gang have got you pulling a camper with your tesla (though in the future that might not be a bad option).
GetWord([Field1], 0)+" "+GetWord([Field1], 1)
GetWord() is the function that you are looking for. The first word = 0. This runs in about 2/3 of the time of a RegEx expression.
Cheers,
Mark
Mark just called me and told me off.
It was like being back at school.
I'll go away and think about what I've done.
Need to find @mceleavey Gifs library
