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 ?
but even the code will find it difficult if there is no separator…
can i have sample of it if possible
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.
Can you share the sample file to investigate.
sample.txt (29.5 KB)
Main.xaml (4.8 KB) This seemed to work for me as the file was actually Tab delimited.
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)
@balupad14 Thank you so much !! This worked.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.