Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Decimal point to Decimal comma conversion
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Decimal point to Decimal comma conversion
 Login/Join
 
Member
posted
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
 
Posts: 6 | Registered: August 20, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Decimal point to Decimal comma conversion

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.