The currency value needs to be converted to INTEGER on the export. You may wish to round the number
(INT(BRND(currencyValue,10,1))) will return a signed integer, rounded according to the bank specs. -$1,234.50 >> -1235 (INT(currencyValue)) will return a signed integer truncating the pennies. -$1,234.56 >> -1234 "Larry Wilson" <[EMAIL PROTECTED]> wrote: > > Hello list: > >Using �RB 7.0 > >I am trying to create a �text file to b imported into an ISO database >and I am stumped with this problem > >The �negative currency vales needs to be signed while postive values can >be signed or unsigned. > >The following are examples of how they want the data �whole number only > >Negative Amount > > � �Units Position Numneric Value � � � �Symbol � � � � Hex Code > > � � � � �-0 � � � � � � � � � � � � � � � � � � � � � � � �} >D0 > � � � � �-1 � � � � � � � � � � � � � � � � � � � � � � � �J >D1 > � � � � �-2 � � � � � � � � � � � � � � � � � � � � � � � K >D2 > � � � � �-3 � � � � � � � � � � � � � � � � � � � � � � � �L >D3 > � � � � �-4 � � � � � � � � � � � � � � � � � � � � � � � �M >D4 > � � � � �-5 � � � � � � � � � � � � � � � � � � � � � � � � N >D5 > � � � � �-6 � � � � � � � � � � � � � � � � � � � � � � � � O >D6 > � � � � �-7 � � � � � � � � � � � � � � � � � � � � � � � � �P >D7 > � � � � �-8 � � � � � � � � � � � � � � � � � � � � � � � � �Q >D8 > � � � � �-9 � � � � � � � � � � � � � � � � � � � � � � � � � R >D9 > > >As I see it -789 = PQR > > > >My question is how do I convert the values to theses codes ? > >There is a set of values for positive number as well. > >Any help will be greatly appreciated. > > > > >LW > > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
