I have a .csv file that I need to access.
I created an .acx nad a .mas file.
My proble is that te source file contains decimal point instead of comma's. So the data are read as alpha's instead on numbers
Any sugestions?This message has been edited. Last edited by: <Kathryn Henning>,
Windows, All Outputs
Changing the setting for CDN may allow you to read the numbers correctly:
SET CDN = EUROPE
Otherwise, you may have to read them in as alpha, remove the decimals (function STRIP), and then convert them to numbers (function EDIT or ATODBL).
|Powered by Social Strata|