How to convert excel column data into array and each value separated with ;

[Baby123 (Baby)]

Hi Team,
I have one excel and I want to extract the B column data and stored into array of string and each group name separated with ; using UiPath.

Can any one help me to solve the issue.

Attaching is the screenshot for your reference.
Kindly suggest.

Output like this : {A411058;A096876;A107040 etc…}

Regards,
baby

[ppr (Peter Preuss)]

we assume that the excel was read in into datatable (e.g. read range) - dtData

Assign Activity
arrValues | String Array =
dtData.AsEnumerable.Select(Function (x) x("Group Name").toString.Trim).toArray

Assign Activity
strFlatValues = String.Join(";",arrValues)

[Parvathy (PS Parvathy)]

Hi @Baby123

Try this query

 columnBValues= (From row In dt.AsEnumerable()
                                  Select row.Field(Of String)("column name")).ToArray()

resultString = String.Join(";", columnBValues)

Note columnBValues is of DataType Array(System.String)

Hope it helps!!

[Parvathy (PS Parvathy)]

Hi @Baby123

Input:

Query:

Assign activity -> Output= (From row In dtInput.AsEnumerable()
                                  Select row.Field(Of String)("Group Number")).ToArray()

Message Box -> String.Join("; ",Output)

Output is of DataType Array(System.String)

Output:

Regards