[RBASE-L] - Re: ISO Export

[Emmitt Dove]

We used to have to send data to mainframes where the last character of a negative number was encoded as a letter.  This is trivial to do in code using a switch block.  If you are using a report, may I suggest putting your data into a temporary table first and doing the translations, then report against that temp table.

 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
 

Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]