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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Data Migrator
 Login/Join
 
Gold member
posted
In DataMigrator functin to convert $10.00 to 10.00
or $(10.00) to -10.00

thanks


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You could use function CTRAN to replace both '$' and ')' with a blank and '(' with a minus sign, and then use function ATODBL to turn the result into a double-precision number. This assumes the incoming data (FIELD0) is alphanumeric with a length of x (Ax).

FIELD1/Ax   = CTRAN(x,FIELD0,BYTVAL('$','I3'),BYTVAL(' ','I3'),'Ax');
FIELD2/Ax   = CTRAN(x,FIELD1,BYTVAL(')','I3'),BYTVAL(' ','I3'),'Ax');
FIELD3/Ax   = CTRAN(x,FIELD2,BYTVAL('(','I3'),BYTVAL('-','I3'),'Ax');
FIELD4/Dx.2 = ATODBL(FIELD3,'x','Dx.2');


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 


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