Identify Non Printable Special Characters

General
Enthusiast

Identify Non Printable Special Characters

Hi,

 

I have loads of tables and trying to find which of the field in a table have non printable special characters.

Is there any way to find the special characters with their type.

 

Table A  Table B  
Col 1Col 2 Col 3Col 4Col 5
A1 Xy44Old
B2  55New
C  Zs Old

 

I am trying to find a query which returns nothing for Col 1, extra space cell value for Col 2, extra space for Col 3 & 4 and nothing for Col 5.

 

RESULTS   
Table NameCol NameValueSpecial Char Type
Table ACol 1 Space
Table BCol 3 Space
Table BCol 4 Space