I was just providing a method using carriage returns and lists, not the entire code. It's fairly simple to find out if the data delimiters are correctly interpreted, or embedded in the data since the list lengths (fields) will be wrong. Those that don't match the field count can be saved to another list for further analysis and cleanup.
Obviously, a direct loading utility into the database is preferable over using CF. >> 2) Use the awesome Ostermiller utilities at >> http://ostermiller.org/utils/CSV.html to actually parse the >> CSV file > >Hmm, excellent resource. One to bookmark I think! Cheers Dave. > >Tim. > >-- >------------------------------------------------------- >Badpen Tech - CF and web-tech: http://tech.badpen.com/ >------------------------------------------------------- > RAWNET LTD - independent digital media agency > "We are big, we are funny and we are clever!" > New site launched at http://www.rawnet.com/ >------------------------------------------------------- >This message may contain information which is legally >privileged and/or confidential. If you are not the >intended recipient, you are hereby notified that any >unauthorised disclosure, copying, distribution or use >of this information is strictly prohibited. Such >notification notwithstanding, any comments, opinions, >information or conclusions expressed in this message >are those of the originator, not of rawnet limited, >unless otherwise explicitly and independently indicated >by an authorised representative of rawnet limited. >------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189944 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
