(Posted this slightly before Michael's server went kablooey, so I'm trying again...)
Any of you folks know a way to get Excel, when saving as a CSV (comma-delimited) format, to put the proper amount of commas on each for rows that don't have all the data? Say I've got five columns being used, A-E, and I've got 20 records, with varying amounts of columns being used. What I'm getting is inconsistent numbers of fields for each row in the CSV file. Some will have five fields (i.e. four commas), some will have one field but still with four commas (which is fine), and some will have less than four commas (which breaks my import app). I'm thinking I'm going to have to add an automated step in the process between file upload and import, to sniff through every damn row in the uploaded file and add the proper # of commas onto the end to make it compliant. Ick. I'd much rather put some proper instructions on how to export your Excel file (for those folks who use it). Any thoughts? Thanks in advance - --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
