[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] PeopleSoft SQR question



Hi Tara,

It would help if you could be a little more descriptive about your 
problem.  If I am reading your question correctly, you are trying to enter 
a number where the first x digits are the dollar amount, and the last two 
digits are the cents.  You could read in the amount, verify that input is 
as expected (make sure that every value is a digit, for example), and then 
divide the resulting number by 100.

HTH,
Don

> Hi,
> 
> I have an sqr that is reading a flat file and populating a table. 
> I'm encountering an issue with the handling of a dollar amount.  The
> last two digits should be the cents amount.  However, I can't 
> determine where the dollars and cents are being manipulated in the 
> process.  My short term fix was to change the field positions to get
> the correct dollar amounts.  This only works because in this 
> particular flat file there are no dollar amounts with cents.
> 
> Any suggestions.
> 
> Thanks.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users