Importing Data from Excel - Degree Symbol
Bob Rasmussen
ras at anzio.com
Tue Feb 7 21:26:01 PST 2012
We're both working way too late!
The degree symbol is hex B0 in Unicode and in Latin-1, and in Windows
codepage 1252. It's something else in DOS, also known as codepage 437 (I
think it's hex F8, but I'm lazy). When you read the file into Excel, do
you get a chance to indicate its encoding?
On Tue, 7 Feb 2012, Scott Walker wrote:
> I'm importing data from Excel.
>
> One of the fields contains the degree symbol.
> When I look at the data with hd, it shows the degree symbol as hex b0.
>
> After import to fp, the degree symbol is obviously not shown but the field
> does have a strange character in it.
>
> Is there an easy way to convert this to the text "degrees" in the fp file.
>
> Regards,
>
> Scott
>
> Scott Walker
> RAM Systems Corp
> (704) 896-6549
> ScottWalker at RAMSystemsCorp.com
> www.RAMSystemsCorp.com
>
>
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
Regards,
....Bob Rasmussen, President, Rasmussen Software, Inc.
personal e-mail: ras at anzio.com
company e-mail: rsi at anzio.com
voice: (US) 503-624-0360 (9:00-6:00 Pacific Time)
fax: (US) 503-624-0760
web: http://www.anzio.com
street address: Rasmussen Software, Inc.
10240 SW Nimbus, Suite L9
Portland, OR 97223 USA
More information about the Filepro-list
mailing list