Search results for query: *

Skip, THANK YOU SIR. I used an extra variable (prepBuffer) to trim out the first 2 special characters and the exact number of characters to import and then split that. Works on both CSV files. Man you MADE my week. Thanks for taking the time to help me work through this. [2thumbsup] [thumbsup2]

Part of the problem is that one of the files has the character the other doesn't. And I'm having a hard time even finding what the character is, there's a bunch that show up as boxes... Is there a way in the line input to only input the first 76 characters? That's the number of characters in...

Hi Skip, yeah that's why I use Chr(9) as the delimiter, it works. I fixed the funny character problem by trimming the first 2 characters off varField(0). If (Mid(varFields(0), 3, 5)) <> "Test1" Or _ Solved! Works perfect. My last problem is the line input recognizing the end of the first...

I typed the varFields out of sequence which was causing that error. Now I've got another can of worms with this. There's potentially 2 CSV files, generated from different sources, that seem to encode the CSV file differently. They both create a funny looking character first character, kind of...

Hi Skip, Thanks, completely didn't see that. Now it gives an error, "Subscript out of range".

I've posted this question elsewhere, but no one seems to know how to fix the code... Before importing from a CSV, I'm trying to verify: 1) How many fields are present before importing a csv file 2) If the number of fields is correct, are the field names correct as well... The CSV file uses...