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-boun...@leafe.com> On Behalf Of Jean Laeremans Sent: Friday, April 16, 2021 11:10 AM To: profoxt...@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.caza...@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. _______________________________________________ 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/mwhpr1001mb2144c1f035f0181c6d0a17b0d2...@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.
