Differences

This shows you the differences between two versions of the page.

--- syntax:functions:trimstart [2015/03/29 21:48] – elenap
+++ syntax:functions:trimstart [2021/08/11 15:20] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== TrimStart(text) =====
+====== TrimStart(text) ======
+Category:  Text function
-Trims leading spaces from the //text//. Trailing spaces will be preserved. Can be used with //'text'// or //[field]//.
+\\
-Will be applied to each row of the selected column.
+=====Description=====
+This function trims off all leading spaces and other non-printing characters (see //Remarks//) from //text//.  Trailing spaces are preserved.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|text|Text|Any text value or other value that can be implicitly converted to text if required.|
-^  Example  ^  Result  ^
+**Return value type:** Text
-|  trim(' Columbia')   |  Columbia  |
-|  trim([company])  |  (removes the spaces before the company name)  |
-**See also**
+\\
-  * [[syntax:functions:trim]]
+=====Remarks=====
-  * [[syntax:functions:trimend]]
+Besides spaces, it also removes other non-printing, white-space characters such as tabulations, form feeds, etc. [[https://docs.microsoft.com/en-us/dotnet/api/system.char.iswhitespace?view=netcore-3.1#remarks|The full list of removed white-space characters]].
+\\
+=====Examples=====
+  trimstart(' Columbia') //Returns 'Columbia'
+  trimstart(' Columbia  ') //Returns 'Columbia  '  (Trailing spaces retained)
+\\
+===== See also =====
+  * [[syntax:functions:trim|Trim(text)]]
+  * [[syntax:functions:trimend|TrimEnd(text)]]