How to write list of values in csv/excel in one cell only

Help Studio
, ,
1

How to write list of values in csv/excel in one cell only?
I am extracting multiple value using 1 matches activity.
How to save all the value in one variable ?

2

Hi @Smruti_Smita_Samal

Can you share some sample input\output?

Regards
Sudharsan

3

Thanks for your reply.

image
image1038×310 6.5 KB

please check the image.
These are the output collection which I want to save in excel/csv in one cell.

4

Is this is input? @Smruti_Smita_Samal

and you need to write this whole text in one excel cell?

5

Yes I need to write all the content in one cell

6

Hey there @Smruti_Smita_Samal ,

If your example is a whole string you could use the .replace() function to get rid off the
unwanted elements like <‘span>, <’/span>, [ , ], etc.
Use link to read more about .replace()

Example:
Use an assign activity
string1 = string1.replace(“[”,“”)

7

Matches activity returns 10 values in span tag.
How to concatenative all the value in one variable so I can use that variable later or to save that data to csv in one cell.
Html tags are not important for now. I can replace it later.

8

Entire process have 3 matches activity.
1st match returns - Name
2nd match returns - Age
3rd one return (Subject like)- Math, science, History.
So Basically I want the csv like below format.

Name Age Subject

Amit 24 History, Math

I am able to save Name and age value.

9

Str=String.Join(“,”,MatchesOutpt.Cast(of Match).Select(Function(M) M.Value).Toarray)