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-boun...@leafe.com> On Behalf Of Gianni Turri Sent: Saturday, April 17, 2021 9:51 AM To: profoxt...@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 <rk...@invaluable.com> wrote: Thanks, Gianni. I can't really dictate to my customers what spreadsheet application to use. -----Original Message----- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Gianni Turri Sent: Friday, April 16, 2021 6:30 PM To: profoxt...@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] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/mwhpr1001mb2144704197c8121d92feb4f5d2...@mwhpr1001mb2144.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
