I have a job due ASAP of course and I need some input on a code to add a zero to the end of a line if needed.
There is a field in the database that contains entries like the following: CALL FORWARD BUSY - $1.2 What we need to do in the case of the above sample is add a zero to the end so it looks right. Some of the entries have a price that is displayed correctly like this: CALL FORWARD BUSY - $1.49 The code needs to do two things. First is check to see if the data field has any data in it since some records do not even include this information. Second is to check if there are two decimal places in the existing data and if not add a zero to make it correct. Who ever merged all this data did not realize that it had dropped the ending zero on the prices. Thank you for any help. Bob McGuire Digital Print Services +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --
