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