There's an easy to overlook option in the dialog box when opening databases. When you see the checkbox to indicate that the "First row contains column names", just to the right and down one row there's an option to offset the loading start point. Set the "Lines to skip at start" option to 1, and you'll be on your way.
No programming or use of the Utility program needed, so no fun for me this time.
However, the dialog does not go that far. When I provide the source file name and select NEXT, that's all she wrote. After waiting a while and then check the Task Manager, Monarch has stopped responding. Monarch really does not like a lonely comma in the first record and I never get to the dialog screen with the first line check box.
That's why I thought I needed to use something like PREP to get rid of the first line before Monarch tries to open the file.
BTW, I would have included this in the first post but to be honest, I never thought of the check box and was zoned into a batch based solution.
Fun Fun Fun
Funny, that's not what happened with my little test file. No lock ups with:
I came up with a one line batch file you can try:
No promises, though, because your symptoms seem to indicate that something else may /Bbe at work here.
Try it and see how it goes...
OK. I've verified that, yes, Monarch does lockup with a comma as the first line. My test file had 1200 lines and it did not like the comma.
Data Kruncher's routine effectively removes that comma, but leaves it as a blank line. Monarch did not like this file either.
This line of batch will effectively remove the first line of the file:
If for some reason the above routine does not work, just add the tokens option:
Thank you Nick and Kruncher for your efforts and feedback,
The Monarch Utility suggestion did not work. The batch did. However, with 190,000 records in the file, it takes a few minutes. But it works.
With a small sample of the file (eg. first 50 records) Monarch opens it but displays no data nor fields on the subsequent screens.
Thanx again!!!! Great forum!!