In that case the text needs to either be inside of double quotes or the entire file needs to be delimited with tabs (I prefer TAB-demimited files as there it is easier to work with and does not increase the file size like double quotes will. If you can get the files generated with TABs then you would be good to go.
HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications >>> Find out how iMS Stacks up to the competition: >>> http://www.coolfusion.com/imssecomparison.cfm --- On Wednesday, January 19, 2005 11:45 AM, Victor Moore scribed: --- > > Hi, > > I have a question regarding importing a csv file, that contains commas > in some of the fields. As a result those lines are screwing the import > process. Unfortunately I don't have any control over the content of > the files. I am sure that other people had the some issue an I was > wondering how they resolved it. > > Thanks > Vic > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191095 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
