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]

Happy to help : ) @sriniprad08 

Cheers and have a nice day!

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the help. I need one more help. Is it possible to do mark only where the "GGG" or "gg" is present as 1 and others in the same row as 0?

As marked in the below pics. So the flow should keep track of the contents from the "To" section .

Thanks

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the help :). It works. One more modifications please for e.g in the below 1st row in the "To" column GGG appears twice. Is it possible to count it as 1 even if it appears more than 1 time in that row please?

thanks,

Sri

[atcodedog05]

Hi @sriniprad08 

Can you provide some sample input and expected output excel It will help us get a better understanding of the usecase.

We will be happy to help : )

[sriniprad08]

Hi @atcodedog05 ,

Sure thank you :). Please find attached. The one marked in yellow is appearing in row 1 with twice "GGG" but the second one has to be 0 . Means if its appear more than one time in a row it should be marked as 0.

2) Also currently the filter is only based on ggg is it possible to add more than one condition for filter like along with "GGG" also look for "AAA"? 

Please let me know thanks for the help :)

[atcodedog05]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you so much :). Couple of questions. Can  you please let me know what does this below regex does?

Also currently the filter is only based on GGG is it possible to add more than one condition for filter like along with "GGG" also look for "AAA"? 

Thanks 

Sri

[atcodedog05]

Hi @sriniprad08 

Add Or contains for more checks like below.

REGEX_Replace([To], "([\u,\.]+)\s?.*<(.+)>", "$1")

[\u,\.]+  means accept only letter, comma, dot

([\u,\.]+) means capture this part

<(.+)> is for email part which is between <>

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you so much :). Actually i am trying to modify the workflow which you created earlier for me to accommodate the previous conditions of 

1)The one marked in yellow is appearing in row 1 with twice "GGG" but the second one has to be 0 . Means if its appear more than one time in a row it should be marked as 0.

2) Also currently the filter is only based on ggg is it possible to add more than one condition for filter like along with "GGG" also look for "AAA"? 

I am trying to make the modifications but i am not doing it properly. Can you please help me with adding the above conditions to the attached workflow ?

Thanks again :)

These are two parts i need addition in the attached workflow.

Sri