jfmcel Posted September 14, 2001 Share Posted September 14, 2001 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? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted September 15, 2001 Share Posted September 15, 2001 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. Link to comment Share on other sites More sharing options...
jfmcel Posted September 16, 2001 Author Share Posted September 16, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8229 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now