[Info-vax] PERL for OpenVMS Alpha that will install on V8.4

VAXman- at SendSpamHere.ORG VAXman- at SendSpamHere.ORG
Mon Dec 2 09:07:22 EST 2013


In article <14guma-e93.ln1 at news.chingola.ch>, Paul Sture <nospam at sture.ch> writes:
>Paul Sture wrote:
>
>> VAXman- at SendSpamHere.ORG wrote:
>>>
>>> Quote all?  I'll assume that means that all of the CSVs are quoted?
>>>
>>> What about monetary values?  This particular customer is taking in
>>> data from international customers with different currency cirteria.
>>
>> I don't understand your question.  To me, QUOTE_ALL means that numeric
>> fields can contain commas without causing havoc when the subsequent CSV 
>> reader processes the file.
>
>Hmm, I've just had a poke around in a couple of CSV files and see single
>quotes in there too, that being the thousands separator in Switzerland.
>
>And I've just remembered why I stopped using Apple's Numbers spreadsheet
>where CSV files are concerned.  I've got a CSV file here which only
>quotes the character strings which contain a comma. E.g. 
>
>2013-01-28,"some text, containing a comma",two words,1'123.45

Which is how the client needs to see the data.

>
-- 
VAXman- A Bored Certified VMS Kernel Mode Hacker    VAXman(at)TMESIS(dot)ORG

Well I speak to machines with the voice of humanity.



More information about the Info-vax mailing list