Sandy Posted February 29, 2008 Share Posted February 29, 2008 Can someone help me with a CSV export? I have created a CSV export, but when I import it into notepad, the quotation marks are there. The recipeint of the export says not to use excel. What do I need to do?smiley-undecided Quote Link to comment Share on other sites More sharing options...
indii Posted February 29, 2008 Share Posted February 29, 2008 dear sandy, try using neo office. you can use many spreadsheet formats there. and in my opinion it is much more powerful than excel. and its free to dowload Quote Link to comment Share on other sites More sharing options...
Sandy Posted February 29, 2008 Author Share Posted February 29, 2008 I looked that up, and it is only for macs?? I just need one long csv data string to export out without the quotation marks. Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted February 29, 2008 Share Posted February 29, 2008 The PC equiv would be Open Office. Or actually vice versa, NeoOffice is a MacOS "Aqua" port of Open Office. I do not understand what "one long csv data string to export out without the quotation marks" would be, though. You do know what "csv" stands for, yes? Quote Link to comment Share on other sites More sharing options...
indii Posted March 1, 2008 Share Posted March 1, 2008 dear sandy, mr.hunter is right. use open office it can be found at http://www.openoffice.org and it works in windows too. also if u want to keep using excel , my suggestion would be to expand your explanation by giving an exampe of what is that you want and what is really happening. i am sure mr.hunter will be able to help you as he has helped me and 1000 others numerous times. Quote Link to comment Share on other sites More sharing options...
Sandy Posted March 1, 2008 Author Share Posted March 1, 2008 I do know what a csv file stands for. I need to have data from Filemaker... comma delimited to export to another software package, or for them to grab it. The format they need it is: ABCE,123,CustomerName,,,, etc. In filemaker the characters have quotation marks and that is what is being exported. I need it without. Did that make more sense? Quote Link to comment Share on other sites More sharing options...
LingoJango Posted March 1, 2008 Share Posted March 1, 2008 Can you be absolutely certain there won't be a comma somewhere inside a field? For instance, JohnDoe,7, Rosehip Street,Austin,TX The quotation marks are there precisely against that possibility. As far as I know, CSV files always have them (but you're allowed to surprise me). I guess you could run a batch file to delete the quotation marks if you're certain there are no "inner commas", but there have got to be better solutions. Maybe you could export to csv, then import the content of the csv file into a global FM field, then process the quotation marks within FM, and then save the field content to the same file name as before. Quote Link to comment Share on other sites More sharing options...
Sandy Posted March 1, 2008 Author Share Posted March 1, 2008 Thank you so much...that makes total sense. I never looked at it that way. I may have to create a gloabal field. I do know in this case there are not any commas...at this point, but their is always user error. I did not error check against this. I got the format from the software company, and that is what they gave me, and I have been going nuts trying to figure it out!! Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.