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”