I’m sure this is super-simple for someone that knows what they’re doing…but I’m not a programmer and am stumped.
All I want to do is extract values from an email sent in a consistent format. I have the email webhook setup, which works fine… and have tried lots of combos of using the parser module…but don’t know what i’m doing!
in the email, it contains the following text:
We are pleased to confirm that your order has now been shipped.
Excellent expression! Let’s make it a little more flexible to allow white space between the label and the actual value, as well as look for digits only for the our reference and your reference assuming only digits are allowed there. You can use regex as a pattern matching service that will be flexible enough to catch even formatting issues if you want but smart not to capture stuff that appears invalid. Up to you.
How about one that doesn’t require an additional module? These are presented in a Set multiple variables module; but you could just use the expressions wherever you want the values:
@JimTheMondayMan very cool use of replace with regular expressions.
I like your use of prefixed white space and other characters before the labels in the lookbehind (?:.|\s) – very nice addition.
But a point of contention on the use of “an extra module” – your Set Multiple Variables uses an operation just like the Text Parser would so I am not sure this approach would save any operations.
Also the text parser tool has been updated and supports “named” groups now so an expression like
(?<number1>\d+) and (?<number2>\d+)
for the text string
this is 1234 and 5678
generates this output bundle
You can see the text parser effectively sets the necessary variable names for use in subsequent modules.
@Noah I think along with the array aggregators and iterators, routers and effective use of the core Make functions, learning Regular Expressions is absolutely a terrific investment in time. RegEx’s have been around for decades and are most definitely a “secret sauce.”
Wow this is helpful. In using the example above, I tried this, but the problem I’m encountering is each line I find is creating a separate Bundle. Then when I try and import that info into a google sheet, it is putting each line on a different row. How do I fix this?
