I occasionally find truncated strings in a data audit. These usually appear when a data item N characters long has been entered in a free-text field with a character limit smaller than N. Detecting truncations programmatically is difficult and not always successful. This post describes the latest of four methods I’ve tried.

Source: LXer – Detecting truncations: another sometimes successful method