Importing Poorly Formatted Text File

Question

Importing Poorly Formatted Text File

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004366 More actions · Answer 1

Thank you for the feedback.

Shifting gears to your latest and I have to ask, where did that particular file come from?

Thinking about the problem at hand with that file, is the format for each section (1 per DN) reliable insofar as position on the line for each "line type"? If so, this could be incredibly easy to solve because that would make it a simple substring/screen scraping problem. I'd just read a whole block as a single string (including the Cr/Lf combinations and map it out for substring extraction.

Also (and asking because the file you attached is obviously a snippet of a larger file), does that last section end with the constant string of dashes as the other sections do?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004366 More actions · Answer 2

Ah... scratch one of those questions. I see that the first section has quite a few extra line types. I do, however, still need to know if the last section in the file has all the dashes at the end of the section that the other sections do.

That does bring up another question, though. Which "fields" do you want out of that file?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)