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

Help Studio
, ,
1
  1. Read the attached input file (Input Sheet).
  2. Create an output sheet in the same input file.
  3. In output file there will be 3 columns as First Part, Second Part, Third Part.
  4. Split the data of each row from input file into 3 part and write the first part in First Column and second part in Second Column and same with third part in Third Column.
  5. Also replace the “,” part from the second part with “.”.

For example-

Input - (‘Y-ZTA’, ‘18.5 X 9.75 - 12 X 3.50 - 20 - RODA DE ALUMÍNIO’, ‘3’)

(‘A-GRD’, ‘24,7 X 10,5 - 8 X 2,95 - 18 - RODA DE FIBRA’, ‘2’)

Output-

[image]

2

Hey @Kailash_Singh

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

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