In the end my client will be doing the export from excel. So I would like to make it as simple as possible.
/Dustin On 3/6/06, Brent Nicholas <[EMAIL PROTECTED]> wrote: > Do you have the option of using a different delimiter? Or is this after the > fact and there is no going back? Anyway, we alway pick a really odd > delimiter that is very unlikely to show up on data. > > 2 cents. > > BN > > > > Brent Nicholas - EclecticDetroit, LLC. > http://www.EclecticDetroit.com > 248.767.5516 > [EMAIL PROTECTED] > > Brent Nicholas - Michigan DJ Service > http://www.MichiganDJService.com > 248.767.5516 > [EMAIL PROTECTED] > > > Do > > > >From: Nando <[EMAIL PROTECTED]> > >Reply-To: [email protected] > >To: [email protected] > >Subject: Re: [CFCDev] Excel CSV Parsing > >Date: Mon, 06 Mar 2006 21:02:45 +0100 > >MIME-Version: 1.0 > >Received: from DWS047.cflib.org ([199.231.128.19]) by > >bay0-mc2-f5.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 6 > >Mar 2006 12:12:31 -0800 > >Received: from GW2.webcontrolcenter.com ([63.134.207.7]) by cflib.org with > >MailEnable ESMTP; Mon, 06 Mar 2006 15:09:13 -0500 > >Received: from mail5.webcontrolcenter.com [216.119.106.46] by > >GW2.webcontrolcenter.com with SMTP; Mon, 6 Mar 2006 13:03:18 -0700 > >Received: from adsl-62-167-101-187.adslplus.ch [62.167.101.187] by > >mail5.webcontrolcenter.com with SMTP; Mon, 6 Mar 2006 13:02:46 -0700 > >X-Message-Info: UZmYcfFpTCdhvqqoIdOFssdwKCv7GAc1TeurgIoydRY= > >User-Agent: Thunderbird 1.5 (Windows/20051201) > >References: <[EMAIL PROTECTED]> > >Precedence: list > >Return-Path: [email protected] > >X-OriginalArrivalTime: 06 Mar 2006 20:12:31.0463 (UTC) > >FILETIME=[4C998770:01C6415A] > > > >If you're looking to do a one time or occasional import, you could look at > >using Navicat, which is an excellent MySQL GUI. > > > >www.navicat.com > > > >Dustin Tinney wrote: > >>I've recently been trying to do a large import of a Excel or CSV file > >>generated from Excel. My efforts thus far have not been good and it's > >>looking like I will have to reinvent the wheel. > >> > >>I have yet to find a good article or paper on 1 Dynamic Datasources > >>using coldfusions built in support of the ODBC Socket with excel. I > >>was able to get my host to "add" a DNS of this type but haven't had > >>any luck getting a query to run using it. > >> > >>So after giving up on the ODBC Socket I figured I'd google my luck on > >>CSV and coldfusion. I have yet to find some one who does NOT assume > >>that the data won't contain a comma. Which to me just seems > >>ridiculous. Excel export to CSV puts "'s around rows with commas > >> > >>Example: > >>"foo, bar", foo, bar > >> > >>would be 3 items the first being foo comma bar. However I have yet to > >>find a good parser already written either in a UDF or even a CFC for > >>any of this. > >> > >>If any one has any help out there it's much appreciated > >> > >> > >>---------------------------------------------------------- > >>You are subscribed to cfcdev. To unsubscribe, send an email to > >>[email protected] with the words 'unsubscribe cfcdev' as the subject of > >>the email. > >> > >>CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > >>(www.cfxhosting.com). > >> > >>An archive of the CFCDev list is available at > >>www.mail-archive.com/[email protected] > >> > >> > >> > > > > > >-- > ><http://aria-media.com/> > > > >Aria Media Sagl > >CP 234 > >6934 Bioggio > >Switzerland > >www.aria-media.com <http://aria-media.com/> > > > > > > > > > > > >---------------------------------------------------------- > >You are subscribed to cfcdev. To unsubscribe, send an email to > >[email protected] with the words 'unsubscribe cfcdev' as the subject of > >the email. > > > >CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > >(www.cfxhosting.com). > > > >An archive of the CFCDev list is available at > >www.mail-archive.com/[email protected] > > > > > you > > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > -- Dustin Tinney [EMAIL PROTECTED] 616-776-6020 Software Journeyman Atomic Object LLC ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
