Text file to excel

[shibani]

HI,
I want to copy data from a text file into an excel sheet. How do i achieve this ? I cannot use generate datatable because there are no proper separators. Is there any code or some activity that i can use to do this ?

[Palaniyappan]

I cannot use generate datatable because there are no proper separators.

Hi
but even the code will find it difficult if there is no separator…
can i have sample of it if possible
Cheers @shibani

[pattyricarte]

@shibani
I think its very hard for the components to determine how it will works ,First the textfile doesnt has a proper format specially for the separator,It we can determine the format of the textfile maybe we can comeup with the logic.

cheers

Happy learning

[balupad14]

Hi @shibani,

Can you share the sample file to investigate.

Regards
Balamurugan.S

[shibani]

@Palaniyappan @Palaniyappan @balupad14
HI
I have attached the text file along. Sorry for the delay

sample.txt (29.5 KB)

Regards

[cwedl]

Main.xaml (4.8 KB) This seemed to work for me as the file was actually Tab delimited.

[balupad14]

Hi @shibani,

Here is the output screen.

@cwedl is exactly true. It is tab delimited csv file.

I have attached my sample.

Shibani.zip (50.5 KB)

Regards
Balamurugan.S

[shibani]

@balupad14 Thank you so much !! This worked.