>>>Hi, I have an issue with creating CSV files since a recent windows update. With certain settings at a client, COPY TO TYPE CSV produces an incorrect file format. Therefore I like to prepare the file in code, however I would need to detect the setting in regional settings, which regional number format is selected. I found the GetLocaleInfoEx API but have not yet found how exactly to use it for the number format. So I am hoping someone has done that already?
>>
>>Quick and dirty:
>>set date short
>>x=dtoc({^1999-12-31})
>>
>>Then analyze x and see what got where.
>
>Since this is an oddness all the time if your decimal comma is not a point, my approach is to use my environment class to store all settings, set the date, point etc to what I need and then reset. Same for APPEND FROM.
>
>So, just give a damn what is current on your system, set what you need
>-figure out what is wrong
>
>*symbolic, SET parameter might be to use with () or &
>lvX = SET(xx)
>SET xx ..
>COPY TO ...
>
>SET xx [lvx]
>
>
>Also, ignore .. TO CSV, use DELIMITED with it's parameters and just copy the header on top of it. This you can create with AFIELDS(). DELIMITED give better control.
>
>HTH
Good point about the header, almost forgot that.
Christian Isberner
Software Consultant