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,
Hi @sriniprad08
Change the option to below
Hope this helps : )
Here is how you can do it.Workflow:
Or
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
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
Its just a config steup for safer processing.
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,
For e.g only aa.bb@g.com in a separate column and g in a separate column. Anything before .com.
Thanks,
Great thank you for the help. Is it possible to get " g" in a separate column. Anything before ".com."
thanks,
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.
Can you provide sample data where you are facing issues.
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.
Thank you so much . Really appreciate your patience and help.
Have a nice weekend,
Happy to help : ) @sriniprad08 Cheers and have a nice day!
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.
Thank you so much . I will go through it and let you know .
have a nice weekend.
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
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?
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 : )
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
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"?
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 <>
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.
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.
Yes that's the logic applied
If you refer to my previous response you would need to add it in the formula to check and it will be looked up.
