email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Need help configuring the program? Have any questions regarding its use?
My attachment contains a few columns, and column#1 is a barcode which consists of the following as an example:

BAG 3565A|2|100321|CHP

I'd like to be able to extract these values along with one of the columns of data and shove into SQL.
Is this possible?

Thanks much,
Rich
Hello Rich,

Yes, it is possible. You can use the following regular expression:

Code: Select all(?'field1'.*?)\|(?'field2'.*?)\|(?'field3'.*?)\|(?'field4'.*)

Take a look at the screenshots below for more details. Also, you have some database examples in the examples section of this website (https://www.emailparser.com/e/by-destination-of-the-data/database) that show you how to use the fields once extracted from the email.
Attachments
regular_expression_1.jpg
regular_expression_1.jpg (118.1KiB)Viewed 725 times
regular_expression_2.jpg
regular_expression_2.jpg (116.57KiB)Viewed 725 times
regular_expression_3.jpg
regular_expression_3.jpg (114.7KiB)Viewed 725 times
regular_expression_4.jpg
regular_expression_4.jpg (117.37KiB)Viewed 725 times
excellent, many thanks!
The entire line is:
BAG 3565A|2|100321|CHP 1 QR_CODE 2018-07-26T15:53:46-04:00

and I've been trying all morning to also extract the "1"
once I get that, I'm done.

Ive tried ignoring alpha characters before the 1...and a ton of other things which are failing..
REGEX isn't my strong suit!
Thoughts?
Rich
;) try this

If you are curious about how regular expressions work you can use this website: https://regex101.com/
It has a regular expression editor that gives you all the hints and you can learn a lot
Attachments
regexp_parsing_emails.jpg
regexp_parsing_emails.jpg (115.55KiB)Viewed 715 times
{bowing in reverence}

thanks...