Matches found by regex get overwritten when exporting them in excel

Help
1

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)?

1st
1st420×534 12.7 KB
image

2

@ykuzin

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