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
Main.xaml (4.8 KB) This seemed to work for me as the file was actually Tab delimited.
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
@balupad14 Thank you so much !! This worked.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.