Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a text file (*.txt) which contains 130,000 rows of records. Its
impossible for Excel to import in full. Even if I use MS Query to extract, it is still not possible because its content is very abstract (combination of table & words). I understand Excel VBA can manipulate text files but I have no idea of how to achieve the below. Every 130 rows of record makes up 1 page (if I import to Excel). This means, theres 1,000 pages in the entire 130,000 rows of records contained in this text file. For each of the page, I only need its first upper half that is row #1 to row row # 65. The VBA should delete row # 66 to row # 130 for every page. For example: my text file row 1 ~ 65 (preserve) row 66 ~ 130 (delete) row 131 ~ 195 (preserve) row 196 ~ 260 (delete) row 261 ~ 325 (preserve) row 326 ~ 390 (delete) €¦..and so on. My file is located in C:\Database\Scrambled.txt It's so scrambled I can't tell if delimeter is Tab or Space. But nevermind, all I need is to delete by rows, as mentioned above. Thanks a lot -- Edmund (Using Excel XP) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manipulating ranges in a different file | Links and Linking in Excel | |||
Manipulating ranges in a different excel file | Excel Worksheet Functions | |||
Manipulating text file data | Excel Programming | |||
Manipulating text of an equation | Excel Programming | |||
Any help in manipulating text appreciated | Excel Programming |