OT: OpenVMS question

[Darren Reely]

Check out the link I had previously posted. It describes that you should 
quote each column value. This will allow your contained content to have 
commas that will not be recognized as separators.

One should note that the CSV file format appears to be just a pseudo 
standard.

By the way. I tried using the semicolon as the separator but it did not 
work for me. Makes me wonder if Excel is altered for different markets, 
or you had to change a preference for it to work.

Darren

Etienne Rompre wrote:
> HI,
>
> Just a suggestion...
>
> If you work with different languages...ex: French and English, you 
> should use ; as the separating code since number in French use , as 
> decimal in number ex: 24,15$ VS . for English ex: 24.15$ or some 
> people place comma after the number in an address.
>
> I had the issue here and standardized on ; since Excel will recognize 
> it as a separating value by default in a CSV file.