How to send Hotkey to excel

Help
, ,
1

Hi team,
In my excel have a column with below data, we need to split by “#” to get multiple columns. can you please help.

E-Mail#Directory Name#Display Name#Description
aabb@gmail.com#aabb#Abbas, Arshad#SDeveloper

we have tried in excel “Text to Columns” option for that need to pass hotkey which does not works.

2

Hi @hasanjpm

The easiest way would be

  1. Use Read Range to read the data in the excel into a datatable
  2. Use Add Data Column activity to create the required columns
  3. Use a For Each Row activity to loop through the data in the excel
  4. Inside the loop, you can use assign activity to split the data of that row

row(“ColumnName”).ToString.Split("#"c)

This will create an array of items after spliting

now, use that array to assign the values into the new columns you added inside the loop itself

row(“New Column”) = SplitArray(0).ToString
row(“New Column 2”) = SplitArray(1).ToString

Now use a Write Range activity to write the data back into the excel file

1 Like
3

Thanks @Lahiru.Fernando it works

1 Like