#WHAT ARE NON PRINTING CHARACTERS WINDOWS#

To see just some of these characters all the time, go into Word’s Preferences (Mac) or File > Options on a Windows computer. I am now assured that I will only pass printable ASCII in the output of my query. To hide the symbols again, click the pilcrow icon once more. Table of non-printable ASCII characters: The following table contains the non-printable characters with their ASCII value in decimal and hex format. I now have to figure out where these bad characters came from and eliminate them but I was able to quickly fix the feed by applying this function in my extract code.ĬASE WHEN dbo.HasNonPrintableChar(column_1) = 0 THEN column_1 ELSE NULL END AS column_1 The non-printing characters are characters for content designing in word processors, which are not displayed at printing.

When these got into the extract they caused some downstream processes to fail because the TAB character was also used as a delimiter. Some columns had control characters like TAB, BS, LF and so on.

In the Always show these formatting marks on the screen section, select the check boxes for the non-printing characters you want to show in your document at all times. I came across some non printable characters during an extract from a database. Advertisement On the Word Options dialog box, click Display in the list of items on the left.

What are non printing characters