troubleshooting Question

Difference in format between excel tab seperated file and filemaker version

Avatar of jarrodprice
jarrodprice asked on
FileMaker Pro
21 Comments2 Solutions922 ViewsLast Modified:
The online ebay management system I use allows me to upload my inventory to the online database with a tab separated file.

I generate this file with filemaker, although the ebay management system was designed to accept tab separated files from excel.

The formating appears to be different in a filemaker tab file verses a excel version.  While my online database accept the filemaker exports for a small number of records, it rejects it if there are more then around 50.  If I take this file, open it in excel and resave it, then i have no problem.

While there are worse things then having to do that every time I upload to my server, I am curious as to why the 2 formating is different.

The one thing I have noticed is that when I open the filemaker generated tab file in a notepad, all of my html code has double quotes "" instead of single.  If I open the same file in excel, I can only see the single quotes.  I can't explain why.

Here is my version:
http://www.diagiodiamonds.com/ebay/Revised%20Items%20Upload%20-%20original.txt

And this is a functional version edited in excel:
http://www.diagiodiamonds.com/ebay/Revised%20Items%20Upload%20-%20fixed.txt

Note, the difference is only visable in a text editor
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 21 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros