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
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¶
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”