| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing file with fixed width, multi-line records
I'm looking for a way in Excel (even if I need to purchase an add-on) to
import .txt files that have fixed record lengths (generally 101 bytes) but have multi-line records. The field lengths are variable and can sometimes carry into the next record. Something like this: 1THIS IS THE FIRST RECORD SEGMENT XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXX 2THIS IS THE SECOND RECORD SEGMENT XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXX 3THIS IS THE THIRD RECORD SEGMENT XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXX 4THIS IS THE FOURTH RECORD SEGMENT XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXX 5ROBERT A SMITH XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 6THIS IS THE SIXTH RECORD SEGMENT XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXROB 7ERT A SMITH XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
| how do I download a csv file with 100,000 records into excel? | Excel Discussion (Misc queries) | |||
| Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Threaded Mode
