Parsing and counting the name and email from a column

[sriniprad08]

Hi Team,

Hope you are well. I need help.

Please find attached the file with input and output.

Please let me know how to go to about it. thanks,

[atcodedog05]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Or

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 

Thank you so much :). Great. I tried with my data set but getting error marked in Red.

Can you please let me know what does it mean? more than 16 records?

Cheers,

Sri

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Change the option to below

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 

Thank you again :). Any reason why it gives the error? Because i am seeing the output is different for e.g first few rows for "From" are blank.

Cheers

[atcodedog05]

Hi @sriniprad08 

Its just a config steup for safer processing.

[sriniprad08]

Hi @atcodedog05 ,

Hope you are well. Is it possible to include the text between <> in a separate column in the flow?

Please let me know thanks,

[sriniprad08]

For e.g only aa.bb@g.com in a separate column and g in a separate column. Anything before .com.

Thanks,

[atcodedog05]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Great thank you for the help. Is it possible to get " g" in a separate column. Anything before ".com."

thanks,