|
I have a character field (CHRG) that is 10 long. It contains formatted dollar amounts. Example: 'bb2,205.00' (b = blank). I want to convert that to a numeric field (FEE) that is 9,2 long. So when I'm done, I have FEE = 000220500 What is the fastest easiest way to do this? Thanks -Adam __________________________________________________________________ Please look below this disclaimer for attachments. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by attorney-client privilege. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Information Systems Manager by telephone at (715)845-3111 postmaster@wipfli.com http://www.wipfli.com ____________________________________________________________________ This message has been generated by MIMEsweeper. This message and attachments have been swept for all known and recorded computer viruses.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
