Separating string in an excel column


Hope these steps would help you resolve this

—use a excel application scope and pass the file path as input and get the output as dt with read range activity

—now use a BUILD DATATABLE ACTIVITY with two columns we want and get the output as dt_final

—use a CLEAR datatable activity and pass the above dt_final as input

—then use a FOR EACH ROW activity and pass dt as input

—inside the loop use a assign activity like this

Intcount = Split(row(0).ToString,” “).Count

Where intcount is a variable of type int32

— then inside the for each row loop use ADD DATAROW activity and mention the property as

Arrayrow = {
String.Join(“”, Split(row(0).ToString,” “).Take(intcount - 1).ToArray()),Split(row(0).ToString,” “).Last.ToString}

And mention dt_final in datatable

Cheers @HeartCatcher