<div dir="ltr">I like the xlate solution for this ... one character to one character substitution ... your data won't overflow any intended field (provided it was originally sized correctly of course).<div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div>--</div><div>Bill McEachran</div><div><font size="1"><a href="mailto:bill.mceachran@gmail.com" target="_blank">bill.mceachran@gmail.com</a>     </font></div><div><font size="1"><a href="http://www.wjmceachran.com" target="_blank">http://www.wjmceachran.com</a>  </font></div><div><font size="1"><a href="http://www.fileproprogramming.com" target="_blank">http://www.fileproprogramming.com</a></font></div></div><div><font size="1" color="#0000ff"><a href="https://ca.linkedin.com/in/bill-mceachran-82a56114" target="_blank">https://ca.linkedin.com/in/bill-mceachran-82a56114</a></font><br></div><div><br></div></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Wed, Jan 25, 2017 at 10:50 AM, Chris Rendall via Filepro-list <span dir="ltr"><<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'm assuming you are importing the Excel file as a CSV file.  If so, I would try the xlate command during import to look for chr("248") and change it to a different character.<br>
<br>
In this example rec(1) would contain the field being imported:<br>
<br>
aa=xlate(rec(1),chr("248"),"d"<wbr>)<br>
<br>
-- Chris<br>
<div class="HOEnZb"><div class="h5"><br>
-----Original Message-----<br>
From: Scott Walker via Filepro-list [mailto:<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.<wbr>celestial.com</a>]<br>
Sent: Wednesday, January 25, 2017 9:32 AM<br>
To: <a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.<wbr>com</a><br>
Subject: Importing Degree Symbol Into Filepro<br>
<br>
I'm importing data from an Excel file.  The Excel data includes the degree symbol in some of the part descriptions.  Filepro does not like that.<br>
Neither does vi.<br>
<br>
Any thoughts on the best way to convert the degree symbol to the text "deg".<br>
<br>
Would it be better to do this to the data outside of filepro (before I import it) or would it be better to handle inside fp.<br>
<br>
Regards,<br>
Scott<br>
<br>
<br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.<wbr>com</a><br>
Subscribe/Unsubscribe/<wbr>Subscription Changes <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/<wbr>mailman/listinfo/filepro-list</a><br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.<wbr>com</a><br>
Subscribe/Unsubscribe/<wbr>Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/<wbr>mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>