I am reading some data from a database and then processing it with the "'Delimited Text Reader" component. It's failing with "Found binary character '_ASC(19)' (19) at line 1." The binary character is some kind of "dash", but not a simple ASCII dash. I'm guessing it's an em-dash or en-dash, but don't know for certain. Unfortunately, I can't change the data in the database, so I have to filter it out with the Pilot Script. I can't figure out how to do that.

I can use "RSubst" on this specific data returned from the database, but I would like to seach for the offending character and remove it or replace it, because I suspect there are more of these errors waiting to spring up. That's where I'm stuck. How can I,

1. Discover the character code that I need to search for, and
2. Replace just that character in the string returned from the database.

Here's the top of the error message:

Found binary character '_ASC(19)' (19) at line 1.
DelimitedReader::IsLegalFormat: Pipeline Pilot exception rethrown
FileDataReader::OpenSource: Pipeline Pilot exception rethrown
DelimitedReader::OpenSource: Pipeline Pilot exception rethrown
FileDataReader::OpenSourceFromProperties: Pipeline Pilot exception rethrown
DataReader::onInitialize: Pipeline Pilot exception rethrown
FileDataReader::onInitialize: Pipeline Pilot exception rethrown
DelimitedReader::onInitialize: Pipeline Pilot exception rethrown
-> 'Delimited Text Reader' ('Delimited Text\\nReader: Number to Keep'); 

Thank you,
Randy Stegbauer