Thanks for poking at this. There's another nuance here in that the user could have a file with the proper columns, etc. received from a 3rd party source but it has the delimiters appropriate to their region, and they simply submit it directly to our import process without first going through Excel. In that case I still need to recognize it's using semi-colons. The ideal process for the user is I just convert it as needed without making them pre-process via Excel or Libre, etc.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Gianni Turri Sent: Saturday, April 17, 2021 9:51 AM To: profoxtech@leafe.com Subject: Re: Variations in CSV settings by region
Hi Kaye,
you are right.
But I couldn't believe Excel didn't have CSV import options like LibreOffice Calc does... So I looked better and found them!
These options are not available when opening a CSV file directly, like in LibreOffice Calc, instead you have to go through this:
- select the "Data" tab on the ribbon - select "From Text/CSV" in the "Get & Transform Data" section
Gianni
On Sat, 17 Apr 2021 10:39:00 +0000, Richard Kaye rkaye@invaluable.com wrote:
Thanks, Gianni. I can't really dictate to my customers what spreadsheet application to use.
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Gianni Turri Sent: Friday, April 16, 2021 6:30 PM To: profoxtech@leafe.com Subject: Re: Variations in CSV settings by region
Use LibreOffice Calc instead of Excel: when opening/importing a CSV or pasting text with delimited data, opens a panel with plenty of options.
Gianni
[excessive quoting removed by server]