Importing Degree Symbol Into Filepro
Kenneth Brody
kenbrody at spamcop.net
Wed Jan 25 09:02:36 PST 2017
On 1/25/2017 11:34 AM, William J. McEachran via Filepro-list wrote:
> 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).
FYI -
In a Windows console, it's character 248 that's the degree symbol.
> 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.
Character 248 already is the degree symbol. (At least in a Windows console
window.)
Is this Windows (he mentions "Excel") or *nix (he also mentions "vi")?
[...]
--
Kenneth Brody
More information about the Filepro-list
mailing list