bernhard Posted May 31, 2006 Share Posted May 31, 2006 Hi guys, Hi Brian, Just tried to download the CSV file with my portfolio information, just to findout that the field content isn't enclosed in quotation marks so that commasinside the text totally screw up the column layout when importing into Excel. Would it be possible to enclose the field content in quotation marks (so that Ican replace "," with an unambiguous field delimiter or offer a file for downloadwith an altenative field delimiter such as colon or tab? Thanks guys. Link to comment Share on other sites More sharing options...
davidmccracken Posted May 31, 2006 Share Posted May 31, 2006 Excel opens Comma Separated Variable Variable files fine. Are you sure you are not trying to import it as text? Link to comment Share on other sites More sharing options...
bernhard Posted June 1, 2006 Author Share Posted June 1, 2006 "Excel opens Comma Separated Variable Variable files fine. Are you sure you are not trying to import it as text?" Sure it does. But it regards EVERY comma as a field delimiter no matter if it is part of the field content or introduced during CSV file generation from the database tables between the fields. That's the problem. Link to comment Share on other sites More sharing options...
bennyboy Posted June 1, 2006 Share Posted June 1, 2006 I just avoid using commas in my photo submissions. Link to comment Share on other sites More sharing options...
Recommended Posts
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