Matches to string

Build Studio
, ,
#1

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?

#2

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

#3

Hi @Gabriele_Camilli
thankyou for your reply

I need it without looping.

#4

image
image1236×702 35.5 KB

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

#5

You can store the Concat of strings in a variable

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

And then write that

#6

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

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