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
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:
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.
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
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
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

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
{bowing in reverence}
thanks...
thanks...
- All times are UTC -
