[CLOSED] Decimal point to Decimal comma conversion
Hi everybody, 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>,
WebFocus 7.611 WebFocus 7.703 Windows, All Outputs
June 02, 2015, 11:57 AM
Dan Satchell
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).