• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Text Parser

Tirezyas

Member
Hi Team, I am using the Email Parser -> Text Formatter -> Text Parser to pull text data from Gmail email. There is data that I want that is separated by space.

is it possible to get that specific data?

For example, I have this dummy text. (HTML version in block quotes)

[image: location] SHIP TO Dick RUSSELLVILLE, KY <https://www.amazon.com/gp/r.html?C=1N85WR5439VWW&K=2L0GXQ581X9U3&

I want to get the text in bold to go to my google sheet for each column respectively. (Lastname, City, State).

is that possible?

SHIP TO</td> </tr> <tr> <td colspan="1" style="min-width:1;line-height:8px" height="8"> <img src="http://g-ecx.images-amazon.com/images/G/01/e-mail/img/softlines/sp.gif" alt="" style="display:block;border:none" width="1" height="8"> </td> </tr> <tr> <td id="m_471936387257558623" colspan="1" style="color:#111111;font-family:Arial,sans-serif;font-size:20px;line-height:20px" valign="top" align="left"> <div class="m_471936387257558623informationText"> Lilith </div></td> </tr> <tr> <td colspan="1" style="min-width:1;line-height:3px" height="3"> <img src="http://g-ecx.images-amazon.com/images/G/01/e-mail/img/softlines/sp.gif" alt="" style="display:block;border:none" width="1" height="3"> </td> </tr> <tr> <td id="m_471936387257558623" colspan="1" style="color:#111111;font-family:Arial,sans-serif;font-size:18px;line-height:18px" valign="top" align="left"> <div class="m_471936387257558623addressText"> RUSSELLVILLE, KY </div></td> </tr> </tbody> </table> </td> </tr>
 

Tirezyas

Member
Hey @Tirezyas

It is not possible to make any specific word from the text Bold.
No, I know that, and I don't care about that. I was talking about the underlined text highlighted in bold letters [ Dick RUSSELLVILLE, KY ]

I want to know how to make it so it only gets the name Dick to go to the name column, city RUSSELLVILLE to go to the city column in my google sheet?

Do you understand what I am saying? There is a space in between [Dick RUSSELLVILLE]. I don't know what I can use as a delimiter in the text parser to only pick the word Dick or RUSSELLVILLE.

I hope I have explained it better now.

Thank you.
 

fgsrdsg

Member
You can use Text match after and before like


Code:
after: <div class="m_471936387257558623addressText">{{space}}
before: {{space}}</div>
 

Supreme

Well-known member
Staff member
Hey @Tirezyas

You can refer to the following screenshot for your above concern.

2022-05-24_16h32_17.png
 

Tirezyas

Member
You can use Text match after and before like


Code:
after: <div class="m_471936387257558623addressText">{{space}}
before: {{space}}</div>
Hi, how would I do it for the line that has RUSSELLVILLE, KY ?

I prolly can separate Russellville but getting KY is proving to be difficult.
 

Tirezyas

Member
Thank you all for the feedback. I will try your suggestions. I also wanted to say that this is not a one-time thing.

These Amazon emails come in that format for many different names, Cities, and States. So I am trying to find a delimiter that is constant across all those emails.

Again thank you for the suggestions, I will try them and I will keep you posted on this.
 

Supreme

Well-known member
Staff member
Hey @Tirezyas

You can use Text Formatter: Replace Text in your workflow but you have to make sure that the content which you are trying to separate with space or comma then it must be in its exact position.

If the content shifts its places then it would give you a different result.
 

Tirezyas

Member
Hey @Tirezyas

You can use Text Formatter: Replace Text in your workflow but you have to make sure that the content which you are trying to separate with space or comma then it must be in its exact position.

If the content shifts its places then it would give you a different result.
Thank you. I played with the text splitter and replace to get something going. And yes they are always in the same position. So that worked out.
 

Tirezyas

Member
I got a big one this time boyz. I have been trying to get my head around it but I cannot. Below are the text and HTML versions of the body of the email. Is there a way to parse the text to get both single and multiple words city names?

I am using the text splitter to help me get the city names. But when the city name has 2 words, it breaks. If the city name has 3 words like Salt Lake City it will break again. Can someone help me or point me in the right direction?

Thanks.

TEXT versions
Your order will be sent to: * Susano Obito SAN FRANCISCO, CA United States *
Your order will be sent to: * ray reese CHARLESTON, SC United States *

HTML versions
<p> <span>Your order will be sent to:</span> <br> <b> Susano Obito <br> SAN FRANCISCO, CA <br> United States </b> </p>
<p> <span>Your order will be sent to:</span> <br> <b> ray reese <br> CHARLESTON, SC <br> United States </b> </p>
 

Supreme

Well-known member
Staff member
Hey @Tirezyas

Could you please share the name of the workflow, so that we check the possibility to extract the address from the complete content?
 

Tirezyas

Member
Hey @Supreme here it is below. Also is there documentation on the text parser for the control switches? (you know like using \n, {{space}} etc...)

Amazon Business Orders Data Extraction​


Thank you for trying to help.
 

Supreme

Well-known member
Staff member
Hey @Tirezyas

We looked into your workflow and it's not possible to extract the state's name from the content. You can use whole shipping address for your work.
 
Top