How to split the gmail messages in lines usign Parse Text

How To
1

Parse Text.pdf (472.8 KB)

Hi There,
I need to split each line received by text email into columns at Goole Sheets. I am aware of Parse Text are able to perform the task however I do not know which “transformer” to use and how to config them.

Thanks in advance
Regards

2

Use Set Variable module to set an array using split():

{85D28446-3E9E-4059-87AB-C2E4E902464C}
{85D28446-3E9E-4059-87AB-C2E4E902464C}702×372 34.8 KB

This will take your email body and create an array, with each value in the array being 1 line.

Then in Google Sheets, you can use the newly created array to set each column value (I’ve used a variable module to demonstrate how you reference each line of your array 1-6):

{B31A70D1-5D21-454D-AEF0-1D439681A955}
{B31A70D1-5D21-454D-AEF0-1D439681A955}756×635 40.6 KB

1 Like
3

Hi XenoMax

Thanks for your support however could you please provide more details ? I’m not getting the results as you have commented !
If I correct undertood should I use 2x modules, insn’t ?

Regards

4

Hi again
After many times I got it !!! :slight_smile:
Thanks very much