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 ?
Hi
but even the code will find it difficult if there is no separator…
can i have sample of it if possible
Cheers @shibani
@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
@Palaniyappan @Palaniyappan @balupad14
HI
I have attached the text file along. Sorry for the delay
sample.txt (29.5 KB)
Regards
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.