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:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Great thank you. Is it possible to extract the text before .com from "Email" field created  instead of "To" field?

thanks

Please find below the image.

Actually when i try with my original data it gives me still <> in the "Mail" section.

[atcodedog05]

Hi @sriniprad08 

Can you provide sample data where you are facing issues.

[sriniprad08]

Hi @atcodedog05 ,

Thanks for the reply. Sorry the data is confidential as it has official and personal email id's not possible to share . I was thinking if we can extract the "Mail" column from the "Email" column instead of "To" please.

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 

Thank you so much :). Really appreciate your patience and help. 

Have a nice weekend,

Cheers,

Sri

[atcodedog05]

Happy to help : ) @sriniprad08 

Cheers and have a nice day!

[sriniprad08]

Hi @atcodedog05 ,

Hope you are well. I have another challenge and i need your help.

Please find attached the excel sheet with input and output. 

Requirement - Need to create an indicator.

if the Column "To" contains GGG or gg then create new indicator column with 1 or 0

But it should also keep track record of which rows it has this text and mark only them as 1 others as 0 while splitting intwo different rows

thanks

Sri

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you so much :). I will go through it and let you know . 

have a nice weekend.

Cheers,

Sri