Add columns and convert text to column delimited by space in excel

Help
3

Hi
no worries
Hope these steps could help you resolve this

–yah we can create new columns inbetween where we need using SETORDINAL method using invoke method
kindly have a view on this thread on how to create a new column in between the existing one

–once after creating two columns like what we need now its time segregate the value from File column
–hope you would have read the table from excel with read range activity and the output variable datatable named as outdt
–now use a for each row loop and pass the outdt variable as input
–inside the loop use three assign activity like this
row(0) = Split(row(0).ToString," ")(0).ToString.Trim
row(1) = Split(row(0).ToString," ")(1).ToString.Trim
row(2) = Split(row(0).ToString," ")(2).ToString.Trim

this will segregate the value to each columns

hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @aferreira054

1 Like