Re: novice: extract comma delimited data

Excellent point. I have more control over the data that we export, when we do these, and I check that there are no commas present in the data. I've been taking them out when they appear (changing the data, because we can). Maybe I'll just start using other delimiters myself.

This is simple enough, especially when we open the CSV 'spreadsheet' with an Excel macro. Just have the macro use as delimiters the character that you want.

Good tip; thanks.

Chris

Darren Brock wrote in message <3725C5D3.F32EBDB3_at_governet.net>...
>The other people answered your question but I feel I have to say
>something about putting data in comma delimited format. If you plan on
>loading that file into something else and telling it that it is comma
>delimited you should make sure that none of the fields are filled with
>text. Commas are commonly used by people and it will throw your loading
>off if there is one in there. I struggled with that once and now when I
>get a comma delimited extract I call and make them change to tab
>delimited and I have had far fewer problems.
>
>Darren
>
>Furkan Khan wrote:
>
>> Folks, I am a novice at SQL, its been quite some time since I used
>> it. Can someone recommend me the best way to dump out data
>> from an oracle table into comma delimited form.
>>
>> I know the the Oracle Navigator allows it via the gui, but I want
>> a sql script or some other scripting utility.
>>
>> Thanks in advance. You can mail me directly also.
>>
>> Regards.
>> Furkan Khan
>
Received on Wed Apr 28 1999 - 22:51:35 CDT