The TRIM, LTRIM, and RTRIM directives trim whitespace from both sides, left side or right side of a string values they are applied to.
Syntax
| Code Block |
|---|
trim :column ltrim :column rtrim :column |
The directive performs an in-place trimming of space in the value specified by the column.
Usage
The trim directives honors UNICODE space characters. Following are the characters that are recognized as spaces by TRIM, LTRIM and RTRIM.
Character | Description |
|---|---|
\t | Character tabulation |
\n | Line Feed (LF) |
\u000B | Line Tabulation |
\f | Form Feed (FF) |
\r | Carriage Return (CR) |
" " | Space |
\u0085 | Next line (NEL) |
\u00A0 | No Break Space |
\u1680 | OGHAM Space Mark |
\u180E | Mongolian Vowel Separator |
\u2000 | EN Quad |
\u2001 | EM Quad |
\u2002 | EN Space |
\u2003 | EM Space |
\u2004 | Three Per EM space |
\u2005 | Four Per EM space |
\u2006 | Six Per EM space |
\u2007 | Figure Space |
\u2008 | Punctuation Space |
\u2009 | Thin Space |
\u200A | Hair Space |
\u2028 | Line Separator |
\u2029 | Paragraph Separator |
\u202F | Narrow No-Break Space |
\u205F | Medium Mathematical Space |
\u3000 | Ideographic Space |
Example
Using this record as an example:
| Code Block |
|---|
{
"id": 1,
"gender": " male ",
"fname": " Root ",
"lname": " JOLTIE ",
"address": " 67 MARS AVE, MARSCIty, Marsville, Mars"
} |
Applying these directives
| Code Block |
|---|
trim :gender ltrim :fname rtrim :lname ltrim :address |
results in this record:
| Code Block |
|---|
{
"id": 1,
"gender": "male",
"fname": "Root ",
"lname": " JOLTIE",
"address": "67 MARS AVE, MARSCIty, Marsville, Mars"
} |