Team,
I am facing difficulties in extracting a data from a data table.
<Step 1 in attached image>
I need to split the above data using “Environment.NewLine” and append the same in string array, so used the below statement in Assign activity.
<Step 2 in attached image>
also tried like.
OUT_ExtractDataTable.Rows(0)(“Column-2”).ToString.Split(Convert.ToChar(“\n”))
But i am getting output like below.
<Step 3 in attached image>
Please help me to get ride of this problem.
Hi
Welcome to UiPath community
Hope this would help you resolve this OUT_ExtractDataTable.Rows(0)(“Column-2”).ToString.Split(Environment.NewLine.ToArray())
Great
OUT_ExtractDataTable is a datatable variable where Rows is one of the method of datatable and (0) is the row index while (“column-2”) denotes the columnname (we can even mention the column index as well) and Split is a method that helps us to remove the newline and convert them to array
with Environment.NewLine.ToCharArray()