Thanks for chiming in, Jeans. I believe you are more of an authority than me on what's Belgian... 😊
Having said that, I've done Zoom calls with my tech savvy client there. When he picks CSV as the output type in Excel, it uses semi-colons and no double quotes in the resulting file. Change the regional settings in Windows to US, commas and double quotes come out.
Writing a validator class is probably the best way to go and thanks to everyone for adding their tips and tricks. As always, ProFox is the place to hang out.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Jean Laeremans Sent: Friday, April 16, 2021 11:10 AM To: profoxtech@leafe.com Subject: Re: Variations in CSV settings by region
HI Tracy,
Those were the days. Files came from a mf and those guys lived in a different universe. I ended up writing a proc. which examined the complete file and rejected for the slighted non compliance with my guidelines. They quickly learned. btw there is NO Belgian version of cvs files. I ended up using ~
On Fri, Apr 16, 2021 at 4:46 PM Frank Cazabon frank.cazabon@gmail.com wrote:
I have never seen a standard when it comes to CSV. I have stopped using Excel and use Libre Office and when I try to save a file as CSV it prompts for Character set, field delimiter and String delimiter.
Would the issue go away if you specified a tab as your field delimiter and no string delimiter? Or do your customers have no control over the production of the files?
Frank.