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: CFCDev@cfczone.org
To: CFCDev@cfczone.org
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: CFCDev@cfczone.org
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
cfcdev@cfczone.org 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/cfcdev@cfczone.org
--
<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
cfcdev@cfczone.org 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/cfcdev@cfczone.org
you
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
cfcdev@cfczone.org 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/cfcdev@cfczone.org