Tab Delimit Import Problems

[jfmcel]

I am importing data from a web submission. I am getting aberent characters that cause FM to create a new record too soon. If I go through the data in Word, I can find and eliminate most of these characters. (Most of the offending characters appear as little boxes in Word.) If I then look at the data in NotePad, I can find a few more. (In NotePad, the character appear as small boxes.) But in the end, I am still having records split up into different records. Any ideas?

[Kurt Knippel]

Are you forced to use a tab-delimited file? If not, try a comma seperated file and see if you get better results.

Run the import through Excel, rather than Word. You can still strip the bad characters, but Excel will output a much better file for importing.

[jfmcel]

I was thinking that approach might work.

I would like to automate the process. I suppose it might be time to start learning some Excel macros.