Import in the face of non-printable chars.

Jean-Pierre A. Radley appl at jpr.com
Fri Jan 11 15:38:27 PST 2013


While importing from a .csv file which was generated from an
Excel spreadsheet, there is a field from which I want to retain
only alphanumeric characters, discarding punctuation like dashes,
parentheses, commas, even spaces.  I have an edit which does this
handily.

But I came a cropper today when some input fields contained a high-ascii
character (happend to represent the degree symbol), and my edit gave me
a blank result.  Even when I bypassed the edit and tried to import the
.csv field as-is, the filePro field came up blank.

How to eliminate or ignore a character outside the 0-128 range?

-- 
JP


More information about the Filepro-list mailing list