Email Parser & Text Formatter [Text Parser]: Return Default Text if Body Text NOT Found

[bro.omar.l.rashed]

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

 

[Supreme]

Hey @bro.omar.l.rashed

We looked into your workflow(UMZ_RLW _1_xxxxxxxxxxxxxxxxxxxxx_Google-Sheet ), checked the parser steps and it all seems fine now in terms to parse the price, tax.

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.

And for this, you can establish router conditions, 1st when the body text contains the text which is required, and on another router, you can pretext the "0.00$".

For eg- If the body text contains required text

2nd router when the body text doesn't contains the text (We tested for "Tax")

For better understanding, you can refer to our tutorial video -

Thanks!