Formatting a number in PowerHouse - version 8.49.E

[Lowe, Chuck J]

I have a file from an outside vendor.  They are sending it pipe
delimited "|", There is an amount field that is left justified. Is there
anyway to take that character field and convert it to a numeric field
without doing INDEX and bit extracts.  Sometimes the field is    123.45
and sometimes 3,123.45.  I thought I could use the FORMATNUMBER function
but that is for doing the opposite. 
 
The vendor states they can not send it unformatted. 
 
Thanks in advance. 
 

Chuck Lowe Quest Diagnostics | Sr. Programmer/Analyst,SYS Billing
System/Denver| 400 Egypt Rd. | West Norriton, PA 19403 USA | phone
610-650-6679| fax 610-650-2111 |  Chuck.J.Lowe at questdiagnostics.com |
www.QuestDiagnostics.com <http://www.questdiagnostics.com/>  

Please think about resource conservation before you print this message

 


------------------------------------------
The contents of this message, together with any attachments, are
intended only for the use of the person(s) to which they are
addressed and may contain confidential and/or privileged
information. Further, any medical information herein is
confidential and protected by law. It is unlawful for unauthorized
persons to use, review, copy, disclose, or disseminate confidential
medical information. If you are not the intended recipient,
immediately advise the sender and delete this message and any
attachments. Any distribution, or copying of this message, or any
attachment, is prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090831/a31249b2/attachment.htm