How to do CSV?

[Mike Matthews - Omnis]

That will force Excel to open as a CSV.

If you have data that contains a comma, then you need to encapsulate each column in quotes.  I think you can now also define what the encapsulation character is, so not just a quote char.

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>

www.lineal.co.uk<http://www.lineal.co.uk/>

www.sqlworks.co.uk<http://www.sqlworks.co/>



On 12 Nov 2023, at 18:22, Das Goravani <goravanis at gmail.com<mailto:goravanis at gmail.com>> wrote:

Caution: This is a message which has originated from outside the organisation. Ensure the sender is trusted and the content is safe before opening links or attachments.



It’s enough to use Comma delimiters and name the file with .csv at the end.

That’s what I left out… the csv extension.


_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com