Matches found by regex get overwritten when exporting them in excel

Hi, all
I have a loop which iterates over matches found by regex. Each match is written into a cell.I noticed that if there is more than one regex match the last one gets overwritten in destination cell. I guess I should print all of the matches within one cell. How can i do that since i cannot use output variable of regex match activity as it is of IEnnumerable type( the collection of matches)?



Just a quick thought, check the count of Regex “match” every time. Try to iterate through the regex values using another loop and write into excel with some delimiter.

If possible, Can you share the files related to your problem statement with dummy data.

1 Like