How to filter a string to check if it only contains a range of ascii chars
807569Jun 23 2006 — edited Jun 23 2006Hi all
i am writing a piece of code that queries a excel spreadsheet and converts it into xml. however when i check a cell in excel and get its value back as a string i need to check that the string is an allowed ascii character
(between ascii 32 to ascii 126)
if an illegal ascii character is found i need to strip it from the string and then return the stripped string.
anyone have any ideas how i would go about checking the string for these illegal ascii chars?
thanks in advanced