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 ?
2 Likes
Hi
but even the code will find it difficult if there is no separator…
can i have sample of it if possible
Cheers @shibani
2 Likes
@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
3 Likes
1 Like
@Palaniyappan @Palaniyappan @balupad14
HI
I have attached the text file along. Sorry for the delay
sample.txt (29.5 KB)
Regards
1 Like
Main.xaml (4.8 KB) This seemed to work for me as the file was actually Tab delimited.
2 Likes
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
4 Likes
@balupad14 Thank you so much !! This worked.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.