Jump to content

Importing Commas and Double Quotes


nutso
 Share

This topic is 5682 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm trying to import a text file that contains commas and double quotes. When I do the import Filemaker removes all of the double quotes and the chops off all of the data after a comma. I know what its doing it, because quotes are text qualifiers and commas are separators. I tried replacing the commas and quotes with escape characters " and ,. That didn't work either.

What should I do?

Link to comment
Share on other sites

Wow, I didn't know that would work with .tab, I knew that you can do this with cvs the other way. However, that wasn't quite what I meant, so be careful with the results. I meant that you should go back to the source application (i.e. Excel, FileMaker, etc., and save the file as a text tab-separated file.

If you don't have access to the original application, then let us know.

HTH

Lee

Link to comment
Share on other sites

This topic is 5682 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.