I have a text file and I want to copy all text/numbers/special characters whatever is there between the keyword (". keyword:" and ". keyword:")
Each row cell data must have the first line where the keyword ". keyword:", appears but exclude that (keyword: ". keyword:" ) in last line because next file data will start from there. The last line of the file do not have a keyword. the sample txt file is zipped and excel file has the example output.
How is this different (other than a better presentation) from the other version you asked?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
you run getTextContent() from Module1.
Thank you. The VBA works great.
But I need the output in excel file same as in text file. Please check the Row 3 and 4 data (first two short lines should be together as in the text file).
Originally Posted by arnelgp
Awaiting a response from the OP.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
