Extract Templated Text From Email Body
I have QuickBase Sync setup to add new leads from incoming emails from vendors. The vendor specific emails are templated, however, I've been unable to extract specific text from a string into a field....
Forum Discussion
So I am trying to do a similar task but my email format that is received is causing me some issues. What do you guys think is a good way to obtain the 6 pieces of data highlighted in the picture? This is the full message blacked out line is company name. there is a league disculoser below a horizontal line at the bottom of the email.
Fields
Date: 04/08/19
Time: 10:00 AM
Government Shipped Amt: 0.00
Government Staged Amt: 0.00
Commercial Shipped Amt: 67,575.93
Commercial Staged Amt: 667,065.64
Thanks for everyone thoughts.
Derek
Fields
Date: 04/08/19
Time: 10:00 AM
Government Shipped Amt: 0.00
Government Staged Amt: 0.00
Commercial Shipped Amt: 67,575.93
Commercial Staged Amt: 667,065.64
Thanks for everyone thoughts.
Derek
- I could probably help you with the formula but I don't have the time now to take to work it all out. Contact me directly on my website QuickBaseCoach.com if you want some one on one assistance where we just fire up a Go To Meeting session and bull our way though the formula together.
Basically I would use the same technique as described above. The nuance that you have is that those last 4 numbers come is "pairs" on the same line so once you grab that text you would need to separate it based on the spaces in between.
Alternatively, you can just plunge ahead with the technique as described above and post back if you get stuck. It will just take a lot longer that way, but eventually we will get to the same place.
