I had a similar situation recently in an export from an old legacy application. (90% of my job)
It may not apply to your situation, but it sure saves me a ton of time, so it is slightly relevant here. (Windows info only here) The data contained every single char (comma, semicolon, TAB, QUOTES[" '], multiple spaces) that it shouldn't, but would happily export the CSV anyway. "DATA","BELLS "WHISTLES", 'MOATS'; dragons ~ and gypsies ","more data" I found out the app used the systems regional delimiter just like Excel does and a simple system change let us export it as PIPE (|) delimited. I found this info somewhere, but I cant find the link for credits. To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start > Settings > Control Panel > Regional Settings. Click the "Number" tab and in the List "Separator" field, replace the current default separator with the one you want to use (pipe symbol | ). Click "OK" to save the change and close. You can now save files as pipe delimited files. In Windows XP there is an extra step involved. When you open the Regional settings window, you have to click customize next to the language choice drop down. That will bring up another window with "Numbers" as the first tab item. Change the "List separator" to whatever you want to use as a delimiter. Why Excel does not have this fearture built in I will never know. Hope that helps. /K -- "The illusion of freedom will continue as long as it's profitable to continue the illusion. At the point where the illusion becomes too expensive to maintain, they will just take down the scenery, they will pull back the curtains, they will move the tables and chairs out of the way and you will see the brick wall at the back of the theater." -Frank Zappa ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
