i have a custom tag to parse CSV files.
Perhaps you can give it a shot:
http://www.cftagstore.com/tags/csv2query.cfm
Try the example here:
http://www.masrizal.com/product/custom%20tag/csv2query/docs%20%26%20examples/csv2query_example.cfm
Copy paste your CSV files into the textarea, and see if it works.
Regards,
Rizal
At 07:15 PM 6/22/2004, you wrote:
>Hi all:
>
>
>I'm writing a little function that parses a CSV file into a query (I know
>this has been done before, but I need it to specifically handle Excel csv
>exports). Here's the snag:
>
>
>Whenever Excel sees a comma or a quote in one of the cells, it wraps it in
>quotes. If it doesn't find either, it doesn't. So for example, here's a row:
>
>
>This is red, "This is sorta ""red""", "This is blue, really"
>
>
>Now, the above is 3 columns in Excel. The 2nd column has quotes around 'red'
>so Excel wraps the whole thing in quotes and escapes the quotes around the
>word red by doubling them. This is relatively easy to handle.
>
>
>The doosy is the third column. Excel found a comma so it wrapped it in
>quotes (which is fine). The problem is, listgetat and other list functions
>are pretty useless to me because it thinks a fourth column exists
>(containing: really").
>
>
>I'm guessing I can probably go down some sort of regular _expression_ hell to
>do this, but is there an easier way?
>
>
>Thanks,
>Rich
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays<http://www.houseoffusion.com/lists.cfm/link=t:4>
>Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:4:167553>This<http://www.houseoffusion.com/lists.cfm/link=i:4:167553>
>Message] [<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2029.1949.4>Fast<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2029.1949.4>
>Unsubscribe]
>[<http://www.houseoffusion.com/signin/>User<http://www.houseoffusion.com/signin/>
>Settings]
>[<https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick>Donations<https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&business=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick>
>and Support]
>
>----------
><http://www.houseoffusion.com/banners/view.cfm?bannerid=40>
>20b1685.jpg
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
