You could have an array with all the special character in it like so:
vb Code:
Dim arr(7) as String = {"!","@","#","$","%","^","&","*"} 'Then loop through the special character array and replace the ones in the csv text with "". For each sc as string in arr myCSVText = myCSVText.Replace(sc,"") Next
Justin




Reply With Quote