My another question How can I use the Replace activity here? To extract the only eMails in the file names.
What should I write in this fields? I am confused a little bit
I want to get only the Emails which are in the file names.
Letโs say these are the files.
And the file names starts with e Mail + Person Name. In this case I want to extract only the emails and write them in the excel.
So here is the file names in the excel
How can I extract the emails and write them in a separate column? I know that I can use Regex but how to loop for each file name?