Text Parser

[Tirezyas]

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>

 

[Pabblymember11]

Hey @Tirezyas

It is not possible to make any specific word from the text Bold.

 

[Tirezyas]

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]

You can use Text match after and before like

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

 

[Pabblymember11]

Hey @Tirezyas

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

 

[Tirezyas]

You can use Text match after and before like

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]

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.

 

[Pabblymember11]

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]

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]

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>

 

[Pabblymember11]

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]

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.

 

[Pabblymember11]

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.