[INUG-Users] An alternative to FreeTDS

[venkat.saranathan at gulfsoft.com]

Alex,

Thanks for the tip. 

-venkat

------Original Message------
From: Alex Greenbank
Sender: users-bounces at netcoolusers.org
To: users at netcoolusers.org
ReplyTo: users at netcoolusers.org
Subject: Re: [INUG-Users] An alternative to FreeTDS
Sent: Jan 21, 2010 6:50 AM

Hello,

> Obviously if the data contain commas, then you should use different
> delimiter.

If the data contains commas then you need to enclose the string in
double quotes, i.e.

foo,3,"blah,blah",7

You then need to double up any double quotes in the output:-

The four columns:
        foo     4       blah","blah     8
becomes:-
        foo,4,"blah"",""blah",8

If you cut and paste this into a .csv file and open it in Excel you'll
see it's correctly interpreted.

Ta,

-Alex





Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU





_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://netcoolusers.org/Search


Sent via BlackBerry from T-Mobile