Focal Point
[CLOSED] Decimal point to Decimal comma conversion

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/3267005676

June 02, 2015, 03:11 AM
Hero
[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).


WebFOCUS 7.7.05