Splitting 2 or more words into different cells in Excel

[RobertRussell_Monsalud]

Good Day.

I am trying to split 2 or more words into different cells in Excel.

The desired output is this:

Thank you.

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Check with the below linq query:

dt = dt.AsEnumerable().Select(Function(row) dt.Clone.LoadDataRow( { row("TextColumn"), Split(row("TextColumn").ToString(), " "c).ElementAtOrDefault(0), Split(row("TextColumn").ToString(), " "c).ElementAtOrDefault(1), Split(row("TextColumn").ToString(), " "c).ElementAtOrDefault(2) }, False)).CopyToDataTable()

Regards

[pravallikapaluri]

Hi @RobertRussell_Monsalud

Word -->Array of String datatype

words=CurrentRow(0).ToString.Split(" "c)

Output

Hope it helps!!

[Sai_chnadrika_Kopparapu (Sai chandrika Kopparapu)]

Hi @RobertRussell_Monsalud

Use Generate Data Table From Text activity

Output:

Sequence3.xaml (7.7 KB)

Regards,

[RobertRussell_Monsalud]

@vrdabberu

dt.AsEnumerable().Select(Function(row) dt.Clone.LoadDataRow( { row("TextColumn"), Split(row("TextColumn").ToString(), " "c).ElementAtOrDefault(0), Split(row("TextColumn").ToString(), " "c).ElementAtOrDefault(1), Split(row("TextColumn").ToString(), " "c).ElementAtOrDefault(2) }, False)).CopyToDataTable()

May I know what would be the solution as I am having this kind of error?

Book1.xlsx (8.8 KB)

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Please check the below flow:

Workbook:
Book1.xlsx (9.5 KB)

Xaml:
Sequence23.xaml (10.0 KB)

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu

I tried to check it but the output is this

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Please check the excel I have attached and also try the xaml I have attached.

Remove the add header’s option in the write range workbook activity and also please check the data table variable you have passed into the write range activity.

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu

I unchecked the add header’s option but the result is still the same.

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Can you share your workflow?

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu

Actually I’m using your workflow but I don’t know why it is not working in my end. Do I need to add an activity?

Sequence23.xaml (10.0 KB)
Book1.xlsx (8.7 KB)

Thank you.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

Hi @RobertRussell_Monsalud

Please change this options in the generate data table activity and give a try:

Regards

[RobertRussell_Monsalud]

Hi @vrdabberu it works! Thank you so much

[vrdabberu (Varunraj Dabberu)]

You’re welcome @RobertRussell_Monsalud

Happy Automation !!

[RobertRussell_Monsalud]

Hi @vrdabberu

May I know if I still need to use LINQ? Thank you.

Best regards,
Robert

[vrdabberu (Varunraj Dabberu)]

No need of LINQ @RobertRussell_Monsalud

Regards