<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3603" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=341005916-31082009><FONT face=Arial size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=341005916-31082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=341005916-31082009><FONT face=Arial size=2>The vendor states
they can not send it unformatted. </FONT></SPAN></DIV>
<DIV><SPAN class=341005916-31082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=341005916-31082009><FONT face=Arial size=2>Thanks in advance.
</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left>
<P style="FONT-FAMILY: Verdana, Geneva, Arial, Helvetica, sans-serif"
align=left><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #333; LINE-HEIGHT: 12px">Chuck
Lowe </SPAN><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 11px; COLOR: #063">Quest
Diagnostics</SPAN> <SPAN style="FONT-SIZE: 11px; COLOR: #666">| Sr.
Programmer/Analyst,SYS Billing System/Denver| 400 Egypt Rd. | West
Norriton, PA 19403 USA | <STRONG>phone</STRONG> 610-650-6679|
<STRONG>fax</STRONG> 610-650-2111 | <A style="COLOR: #666"
href="mailto:Chuck.J.Lowe@questdiagnostics.com">Chuck.J.Lowe@questdiagnostics.com</A>
| <A style="COLOR: #666"
href="http://www.questdiagnostics.com/">www.QuestDiagnostics.com</A> </SPAN></P>
<P
style="MARGIN-BOTTOM: 4em; FONT: 11px Verdana, Geneva, Arial, Helvetica, sans-serif; COLOR: #063">Please
think about resource conservation before you print this message</P><!-- Clinical Trials --></DIV>
<DIV> </DIV></BODY></HTML>
<br>
------------------------------------------
<br>
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.