Importing Degree Symbol Into Filepro

[William J. McEachran]

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).


--
Bill McEachran
bill.mceachran at gmail.com
http://www.wjmceachran.com
http://www.fileproprogramming.com
https://ca.linkedin.com/in/bill-mceachran-82a56114


On Wed, Jan 25, 2017 at 10:50 AM, Chris Rendall via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> 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.
>
> In this example rec(1) would contain the field being imported:
>
> aa=xlate(rec(1),chr("248"),"d")
>
> -- Chris
>
> -----Original Message-----
> From: Scott Walker via Filepro-list [mailto:filepro-list at lists.
> celestial.com]
> Sent: Wednesday, January 25, 2017 9:32 AM
> To: filepro-list at lists.celestial.com
> Subject: Importing Degree Symbol Into Filepro
>
> 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.
> Neither does vi.
>
> Any thoughts on the best way to convert the degree symbol to the text
> "deg".
>
> 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.
>
> Regards,
> Scott
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/
> mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170125/b54c996b/attachment.html>