Excels

Help Studio
, ,
1

Please anyone can help me regarding this

  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 -* First Coloum Second coloum Third
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

2

@ankit.dutt ,

firstly read your excel and the split by , it using

parts = row(0).ToString.Split(","c)

and then access these 3 parts by

firstPart = parts(0).Trim
secondPart = parts(1).Replace(",", ".").Trim
thirdPart = parts(2).Trim

Then use add data row activity and pass below expression and store it in datatable and the use writerange if you want to write in any sheet.

{firstPart, secondPart, thirdPart}

Regards,
Dheerandra Vishwakarma

1 Like
3

Hi @ankit.dutt ,

Your data is quiet confusing, can you please share the input sheet and output sheet in an excel for the reference

1 Like
5

@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
image1000×614 23.6 KB

i am attaching .xaml file

forum_new_r.zip (12.4 KB)

Regards,
Dheerendra Vishwakarma

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

Okay @ankit.dutt

You can check the below workflow,
Sequence.xaml (11.5 KB)

Sequence
Sequence493×997 60.3 KB

It met all conditions as your requirement.

Hope it helps!!

1 Like