Hi
Hope these steps would help you resolve this
—once after getting the datatable use For each row loop and pass the above datatable as input
—inside the loop use a assign activity with expression like this Str_output = Split(row(“yourcolumnname”).ToString,” “)(0).ToString+“ “+ Split(row(“yourcolumnname”).ToString,” “)(1).ToString
Where str_output is a variable of type string
Or
If we want to assign back to the same row then row(“yourcolumnname”)= Split(row(“yourcolumnname”).ToString,” “)(0).ToString+“ “+ Split(row(“yourcolumnname”).ToString,” “)(1).ToString