Importing Degree Symbol Into Filepro

[Scott Walker]

Chris,

I am actually importing from a tab delimited text file that I made from the
Excel spreadsheet.  Sorry, should have made that clear.

I'll give xlate a try.

Thanks for the input.

Regards

Scott

-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+scottwalker1956=gmail.com at lists.celestial.com]
On Behalf Of Chris Rendall via Filepro-list
Sent: Wednesday, January 25, 2017 10:51 AM
To: filePro (filepro-list at lists.celestial.com)
<filepro-list at lists.celestial.com>
Subject: RE: Importing Degree Symbol Into Filepro

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