[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