How can solve that problem using strings activity, and how many way solve that problem

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @Kailash_Singh

Use the same LinQ as suggested by @Dheerendra_vishwakarma in below post with some changes

Excels

@ankit.dutt , you can do it using LINQ, ( From row In in_DT Select out_DT.Rows.Add(row(0).ToString.Split("', '").Select(Function(x) x.ToString.Replace("(","").Replace("'","").Replace(")","")).ToArray) ).copytodatatable [image] i am attaching .xaml file forum_new_r.zip (12.4 KB) Regards, Dheerendra Vishwakarma

Use below LinQ:

(
From row In in_DT
Select out_DT.Rows.Add(row(0).ToString.Split("', '").Select(Function(x) x.ToString.Replace("(","").Replace("'","").Replace(")","").Replace(",",".")).ToArray)
).copytodatatable

That’s it!

Happy Automation

Regards,
Ajay Mishra