ArrayAppend(aryCSV, Replace(NextField, '""', '"',
"all"));
//writeoutput(",[#lstwork#], [#NextField#]");
}
while (len(lstWork) GT 1);
}
-----
attachments are stripped.send it inline.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2003 14:45
To: CF-Talk
Subject: RE: New problem with csv... argghhh
At 08:38 AM 1/30/03 -0600, you wrote:
>I've attached what I use to parse my CS
At 08:38 AM 1/30/03 -0600, you wrote:
>I've attached what I use to parse my CSV's into an array, which I can then
Andy - no attachment!
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http
h blank entries like
,,,.
Andy
-Original Message-
From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 8:08 AM
To: CF-Talk
Subject: RE: New problem with csv... argghhh
Andy,
Because I'm already into this with hours of code, and need at least a
tem
Andy,
Because I'm already into this with hours of code, and need at least a
temporary solution, and as I'm so close with this one, what kind of code do
I need to include in my loop to deal with this specific scenario?
> when it is a,b,c,d it works but when it's a,b,c, it errors out
wow this is clearly the way to go moving forward - but now I need to ask if
I'm so far into this already that I need to bully my way through based on
current contract work/payments, or scrap all these hours...
At 08:11 PM 1/29/03 -0500, you wrote:
>By editing the schema.ini file you can add a t
By editing the schema.ini file you can add a text datasource with CF's
ini file functions. That way you can dynamically add dsn's when the
end user uploads the file. Take a look at the format of the schema.ini
file that is created, it's pretty straightforward.
The fact that these files are very la
At 06:11 PM 1/29/03 -0500, you wrote:
>Create a ODBC Text Datasource to the file one the machine and then
>just use cfquery to turn it into a query...which you can loop over or
THe problem is it's a multi-thousand record product table from multiple
manufacturers and new prices come out all the ti
At 04:56 PM 1/29/03 -0600, you wrote:
>Is your problem like a typical record looks like this :"a,b,c,d" but when it
>is "a,b,c," it error out? Or is your problem when the record is ""?
It's like: row 1 a,b,c,d
row 2 a,b,c,
so it craps out on row 2 (sometimes this is in th
This looks alot easier and faster then what I am doing. I'll have to use
this for the next CSV I upload. Thanks.
Andy
-Original Message-
From: jon hall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 5:43 PM
To: CF-Talk
Subject: Re: New problem with csv... ar
lto:[EMAIL PROTECTED]]
AO> Sent: Wednesday, January 29, 2003 5:12 PM
AO> To: CF-Talk
AO> Subject: Re: New problem with csv... argghhh
AO> With all the work you've put into this solution, I hate to even say
AO> this, but may I suggest a better way, that will should a lot of hea
Jon,
what does a sample INI look like?
Andy
-Original Message-
From: jon hall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 5:12 PM
To: CF-Talk
Subject: Re: New problem with csv... argghhh
With all the work you've put into this solution, I hate to even say
this, bu
With all the work you've put into this solution, I hate to even say
this, but may I suggest a better way, that will should a lot of headaches?
Create a ODBC Text Datasource to the file one the machine and then
just use cfquery to turn it into a query...which you can loop over or
whatever else you
44 PM
To: CF-Talk
Subject: New problem with csv... argghhh
OK so shoot me in the foot - if my csv file has x records and any
of those records have a BLANK field- this won't work... it comes back
with an error in the loop. Is there any way to force it to fill in a
field with a null? Th
]]
> Sent: Wednesday, January 29, 2003 4:44 PM
> To: CF-Talk
> Subject: New problem with csv... argghhh
>
>
>
>
> OK so shoot me in the foot - if my csv file has x records and any
> of those records have a BLANK field- this won't work... it
> com
OK so shoot me in the foot - if my csv file has x records and any
of those records have a BLANK field- this won't work... it comes back
with an error in the loop. Is there any way to force it to fill in a
field with a null? This is especially important with the last recor
16 matches
Mail list logo
