How to do split data while writing a data to excel

[Shobhit_sachan]

hey all,
I want to write this data into excel sheet

,Now i want to split it into each column

[KarthikByggari]

You can split the data by Space and then Trim the each array value.
For example:
Pseudo code -

arrStr = yourString.Split(" ")

while writing into excel -
arrStr[index].Trim

Regards,
Karthik Byggari

[Shobhit_sachan]

do you have any example in workflow?

[Vivek_Arunagiri]

• Use Generate Datatable activity
• Give column seperator as tab or space
• Give row seperator as new line.
• preview options to see the output.

[Shobhit_sachan]

it doesn’t work.

[Divyashreem (Divyashree Muddagangaiah)]

When you mentioned it Doesn’t work you mean Generate date table.? if yes what are the column separator and new line separator you have provided.?