Sticky Spaces

The Sticky Space is the non-breakable space CHAR(160).

In word processing, like MS Word, by applying the sticky spaces between words can avoid wrapping a phrase or a name into two lines. The sticky space looks like a regular space. The MS Word will handle the phrase connected by them as a single word. To put in the sticky space, just press the Ctrl+Shift+Space.

But, it may be a problem during ETL.

HTML uses non-breaking spaces CHAR(160) for multiple spaces. Copying string contained CHAR(160) from web page, or from HTML email, to Excel spreadsheet may cause problem. For example, the VBA Trim function will not remove the non-breaking spaces.

Beware of the 194, 160 pattern.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s