Hi, I want to read and write all email Id with ";" separated in one Cell in excel sheet, where I have email id's row by row in excel

[dinesh.pazhaniyandi]

Hi, I want to read and write all email Id with “;” separated in one Cell in excel sheet, where I have email id’s row by row in excel. kindly help me , pls see the screen shot for reference

expected Output :

[lrtetala (Lakshman Reddy)]

Hi @dinesh.pazhaniyandi

Use below Linq Query

Emails = String.Join(";", DT.AsEnumerable().Select(Function(row) row("Email").ToString()))

Regards,

[ashokkarale]

@dinesh.pazhaniyandi,

1. Use Read Range workbook activity to read the Email column. It will give you a Datatable. for example dtInput.
2. Use assign activity like this

strOutput = String.Join(";"c,dtInput.AsEnumerable().Select(function(x) x.Field(Of String)(“Email”)).ToArray())

3. Use Write Range or Write cell activity to write the strOutput back to excel file.

Thanks,
Ashok

[dinesh.pazhaniyandi]

Hi Ashok ,

function(x) - > what is this X here?
and X. field

[ashokkarale]

@dinesh.pazhaniyandi,

It’s just syntax we use in LINQ. you can any other name if you want for understanding. This x will hold a data row value while iterating through the data with LINQ.

x.Field will get the Email column value to compare.

[dinesh.pazhaniyandi]

Thanks Working fine this solution

[dinesh.pazhaniyandi]

Thanks You , working fine

String.Join(“;”, dtInput.AsEnumerable().Select(Function(x) x.Field(Of String)(“Email”)).ToArray())

[ashokkarale]

@dinesh.pazhaniyandi,

Glad I was helpful. Kindly close the thread by marking my answer as solution.

Thanks,
Ashok