Quiz Extract Problem

[paddock]

Hi --

It's my understanding that Quiz *always* stores numbers in subfiles in FLOAT form, regardless of how they're defined.  

(Just FYI, QTP on the other hand honors the INTEGER specification.  This still isn't any good for importing into Excel, either, as it's still a binary <thing>.)

However, in this case, what you want is to have the number formatted in "clear text".  Utilize the "ASCII" function and put *that* item into the subfile.  

In order to preserve decimals, however, it gets more complicated.   I've utilized this brute-force approach:

; the units portion
define po-price-units cha*13 = ascii ( po-unit-price )

; the decimal point
define po-price-point cha*1 = '.'

; the cents portion - adjust for number of decimals as necessary 
define po-price-cents cha*2 = ascii ( ( po-unit-price * 100 ) mod 100 )

; finally, the item to put into the subfile
define po-price-sf-item cha*16 = po-price-units + po-price-point + po-price-cents

Hope this helps!
-- w paddock smith
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.