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)


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


Please help…

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

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


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.