Matches to string

[Apchu (shirin sebatina)]

Hi,

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?

[Gabriele_Camilli]

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

[Apchu (shirin sebatina)]

Hi @Gabriele_Camilli
thankyou for your reply

I need it without looping.

[Apchu (shirin sebatina)]

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

[Gabriele_Camilli]

You can store the Concat of strings in a variable

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

And then write that

[ptrobot]

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