Hello Andrew, do you have a small test program that I could run? I'm running NSBasic on a German machine. I usually don't use the comma as the field separator in CSV files, but the semicolon, to avoid confusion with commas in numbers. Adding quotes around all fields (not just text strings) could also help. Kind regards Thomas Am 06.12.2009 um 07:11AM schrieb rmrsoft:
> Interestingly I have only ever used a plain FORMATNUMBER(Val,2) command in my > export routines and although my programs are used all over the world I have > never had a single case reported of a CSV file not loading. > > Might be worth running a test case on a German machine ? > > Al > > --- In [email protected], Andrew Thomas <andrewmarktho...@...> wrote: > > > > Hi, > > > > Thank you very much. I was hoping for a simple single line command but > > there seems not to be one. I'll use your method as it sounds a reliable way > > to do it. > > > > Many thanks, > > > > Andrew. > > > > > > > > > > -----Original Message----- > > From: Hannes Streicher <hstreic...@...> > > Sent: 05 December 2009 11:59 > > To: Andrew Thomas <[email protected]> > > Subject: Re: [nsbasic-ce] Decimal points > > > > Guten Tag Andrew Thomas, > > > > am Samstag, 5. Dezember 2009 um 12:46 schrieben Sie: > > > > > > > > > Can I ask if anyone knows how to make writing numbers to files > > > always have a decimal point as the decimal separator? It seems that > > > some regional settings use a comma, which plays havoc with csv files. > > > > i am german , we use commas :( > > > > i usually end up adding in a function exchanging the comma with a > > point (stringreplace) > > > > > > > > -- > > Mit freundlichen Grüssen > > Hannes Streicher > > > > -- You received this message because you are subscribed to the Google Groups "nsb-ce" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en.
