Make array of string in required format

I am having a data table containing a column “No_” in excel file test.xlsx (8.1 KB)

image

I want all the column values in the required string format:

122|3234|12|42|234|4234|1324|14313|134

Please help…

Hi.
Create an array of String based on your column
arr = dt.AsEnumerable.Select(Function (row) row("No_").ToString).ToArray

finalString = String.Join("|",arr)

Cheers

arrayOfString.xaml (7.7 KB)

1 Like

Thanks a lot @Yurii_Horobets and @Mallik_Arjun

Got the solution

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