Text Calculations

• Compare Strings : Allows two columns to be compared as strings by returning a value of -1, 1, or 0 based on the outcome of the comparison.
• Concatenation : Allows two or more inputs to be concatenated and formatted into one output column.
• Contains : Allows for search of specific values or strings of text within a column's values.
• Pad : Allows for padding of characters before or after an input column's values.
• Replace : Acts as a simplified nested conditional or "true/false" calculation where multiple True conditions may be presented within one calculation.
• Split : Allows splitting of columns' details into segments based on delimiter(s) which present as new calculated columns.
• String Length : Determines a column's total string length per row.
• String Match : Allows for parsing by searching strings for explicitly things like emails, parts of filter expressions, or any other custom defined string. This calculation uses a textual searching language called Regular Expressions (regex). This language uses a small set of special characters --[^.|?*+() to allow for defining the criteria of the search.
• Substring : Select a specific portion of an input by choosing the beginning and end points for all characters in that column.
• To Lowercase : Allows any string input to be standardized to all lowercase values.
• To Uppercase : Allows any string input to be standardized to all uppercase values.
• Trim : Trim characters before or after a value.