bro.omar.l.rashed
Member
Hello, I am using email parser, with some required fields in the autogenerated emails, and others not.
To get what I'm trying to get, I'm attempting to use the Text Formatter, Text Parser option.
For example.
The email to be parsed could say:
Price: $12.50
Tip: $2.50
Item Name: Hamburger
OR
The Email parsed could only have:
Price: $12.50
Item Name: Hamburger
WITHOUT any Tip.
I want to capture the Price into a column in Google Sheets, called Price.
In emails that HAVE a Tip, I want it to capture the $2.50 (or whatever number).
I also want to capture the Item Name, in a column called Item Name in Google Sheets.
But if that text is NOT PRESENT in the email, I want Pabbly to put the default text of $0.00 into the Google Sheets column, instead of a blank value or nothing at all.
My problem is, the Text Formatter -> Parser, if I configure it for
AFTER
Price: $
and
BEFORE
Tip: $
If there's no Tip amount, and thus no Tip text in the email, it doesn't find anything for the Price, even though it is there.
And if I set up the Text Formatter -> Parser to
AFTER
Price: $
and
BEFORE
Item Name: $
(which are both required in the email)
Then if there's a tip, the Price number will also include the words "12.50 Tip: $2.50 ", which is also going to be wrong.
Any advice about how to successfully parse text, WHEN IT EXISTS, from an email, and IF IT DOESN'T EXIST, to simply submit default text, like 0.00 or nothing at all?
Thanks so much.
With peace,
- Omar
To get what I'm trying to get, I'm attempting to use the Text Formatter, Text Parser option.
For example.
The email to be parsed could say:
Price: $12.50
Tip: $2.50
Item Name: Hamburger
OR
The Email parsed could only have:
Price: $12.50
Item Name: Hamburger
WITHOUT any Tip.
I want to capture the Price into a column in Google Sheets, called Price.
In emails that HAVE a Tip, I want it to capture the $2.50 (or whatever number).
I also want to capture the Item Name, in a column called Item Name in Google Sheets.
But if that text is NOT PRESENT in the email, I want Pabbly to put the default text of $0.00 into the Google Sheets column, instead of a blank value or nothing at all.
My problem is, the Text Formatter -> Parser, if I configure it for
AFTER
Price: $
and
BEFORE
Tip: $
If there's no Tip amount, and thus no Tip text in the email, it doesn't find anything for the Price, even though it is there.
And if I set up the Text Formatter -> Parser to
AFTER
Price: $
and
BEFORE
Item Name: $
(which are both required in the email)
Then if there's a tip, the Price number will also include the words "12.50 Tip: $2.50 ", which is also going to be wrong.
Any advice about how to successfully parse text, WHEN IT EXISTS, from an email, and IF IT DOESN'T EXIST, to simply submit default text, like 0.00 or nothing at all?
Thanks so much.
With peace,
- Omar