Matches to string


I am using matches activity and getting the below output
CR123 CR264 CR832…so on

I need it to fill this in the excel in one cell
how can I do it?

Hi @Apchu
I suggest to loop on the matches and then use a write cell for the values

Hi @Gabriele_Camilli
thankyou for your reply

I need it without looping.

Through looping I get values like this and the count is dynamic , I wanna write this in one single cell in the excel

You can store the Concat of strings in a variable

At every loop you assign Var=Var+item.ToString

And then write that

If you don’t want to use a loop, you can join the matched items to a string like this:

myString = String.Join(Environment.NewLine, Matched_Number.OfType(Of Match)().Select(Function(m) m.Value))

Or if you prefer to have a space between the matches:

myString2 = String.Join(" ", Matched_Number.OfType(Of Match)().Select(Function(m) m.Value))

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.