Importing Degree Symbol Into Filepro

[Chris Rendall]

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