Import text file and split data into specific sheets with Applet names

**swethachepur** · 03-10-2014, 03:10 PM

Hi

I am looking for a solution on below code;
this is similar to http://www.excelforum.com/excel-prog...ic-sheets.html

but i am not able to split the data properly

Below code is in .txt file so i will have to parse it and then place them in different columns in Excelsheet. so there are multiple occurances of this Applets in text file. And also Name of the each worksheet should be Applet Name ie "S_A*".

Note: 1. Field Name column is BLANK for some Applets
2. Under Each Name= S_BC10 , we can have multiple Applet Name = S_A11...

Please Login or Register  to view this content.

**LJMetzger** · 03-22-2014, 08:01 AM

Hi,

Try the attached file (written and tested using Excel 2003 on a Vista 64 bit system). The solution I found didn't involve parsing at all, since the DASHED ( "---") lines seemed to define the length of each 'Applet' field.

The algorithm I used to traverse your file was:

Please Login or Register  to view this content.

Please let me know if I missed something or if you have a problem.

Lewis

**apo** · 03-22-2014, 09:07 AM

That's great stuff LJMetzger..

Hopefully the OP comes back to see the effort you put in.. but if not.. at least everyone else can gain from it..

Gonna take me a while to go through it and see how/what you did. but gotta say.. the pseudocode explanation is a nice way of showing us what you were thinking..