Importing Degree Symbol Into Filepro

[Scott Walker]

Josh,

 

Thanks for that….I never thought of using Excel to modify the data BEFORE I try to import it into filePro.

 

I’ll give it a try.

 

Regards,

Scott

 

 

From: Josh Reader [mailto:josh.reader at mercuryelectronics.com] 
Sent: Wednesday, January 25, 2017 11:22 AM
To: Scott Walker <scottwalker1956 at gmail.com>
Cc: filePro Mail Group <filepro-list at lists.celestial.com>
Subject: Re: Importing Degree Symbol Into Filepro

 

In Excel you can easily convert them by doing the following

1. Press Ctrl + H

2. Click into the Find what box if not already there

3. Press and hold the Alt key while typing 0176 and the degree symbol should show up.

4. Press tab or click into Replace with box

5. Type deg

6. Click Replace All button 

Josh

 

On Wed, Jan 25, 2017 at 10:32 AM, Scott Walker via Filepro-list <filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com> > wrote:

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 <mailto: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/f1c7d1d7/attachment.html>