lanhao
02-05-2013, 01:42 PM
Hi there, it's been a while since I've been on here, and I come back with a question/problem.
I am currently trying to set up a text parser for a text file import to excel that is pulled from an old DOS style window screen capture. The issue is that there are a variable amount of these records on any given day, and need to set up some way of importing it.
I was looking at some other coding on this, but then ran into another issue with some of the lines. There are different pieces of data on some rows.
I guess what I'm asking for here is some guidance/help in how to get some coding set up for this format honestly.
I can't put up any specific data (it's proprietary) on this but will just use the example below as a means to try to highlight the situation.
Row 1 - Field A: <info>
Row 2 - Field B: <info> Field C: <invfo> Field D: <info>
Row 3 - Field E: <info>
There are a lot of blank spaces between each record, and they always start with the same character string.
Basically I was hoping for a base direction to go running in with this since each row would be a record, and each field would be entered into different columns.
Thank you in advance for reading this, and any potential suggestions you might have. :hi:
I am currently trying to set up a text parser for a text file import to excel that is pulled from an old DOS style window screen capture. The issue is that there are a variable amount of these records on any given day, and need to set up some way of importing it.
I was looking at some other coding on this, but then ran into another issue with some of the lines. There are different pieces of data on some rows.
I guess what I'm asking for here is some guidance/help in how to get some coding set up for this format honestly.
I can't put up any specific data (it's proprietary) on this but will just use the example below as a means to try to highlight the situation.
Row 1 - Field A: <info>
Row 2 - Field B: <info> Field C: <invfo> Field D: <info>
Row 3 - Field E: <info>
There are a lot of blank spaces between each record, and they always start with the same character string.
Basically I was hoping for a base direction to go running in with this since each row would be a record, and each field would be entered into different columns.
Thank you in advance for reading this, and any potential suggestions you might have. :hi: