.. _remove-whitespace-snip:

======================
Remove Whitespace
======================

Sometimes you need to remove whitespace (spaces) at the beginning or end of text.

Or yuo need to remove a certain character such as a #

Rule Type Format
=========================

    trim(field name)

    trim(field name , character to trim)

Snippits
=========================

Remove spaces
------------------------------------

Removes a space at the beginning or end of the text.  Often refereed to as leading or trailing characters


Default
++++++++++++++++++++++

Rule Type = Calculated Output Field

Rule Attribute = trim(City) : City


Examples
+++++++++

* "Auckland " become "Auckland"

* " Auckland" becomes "Auckland"


Remove Special Characters
------------------------------------

Removes specific characters, other than spaces, at the beginning or end of the text. Often refereed to as leading or trailing characters


Single Character Pattern
++++++++++++++++++++++++++++

Rule Type = Calculated Output Field

Rule Attribute = trim(City,"*") : City


Examples
+++++++++

* "***Auckland****" become "Auckland"

* "***Auckland" becomes "Auckland"

* "Auckland****" becomes "Auckland"


Multiple Character Pattern
+++++++++++++++++++++++++++++

Rule Type = Calculated Output Field

Rule Attribute = trim(City,"xyz") : City


Examples
+++++++++

* "xxxAucklandxxx" become "Auckland"

* "yyyAucklandyyy" becomes "Auckland"

* "zzzAucklandzzz" becomes "Auckland"

* "xyzAucklandxyz" becomes "Auckland"