Text Calculations

• Comment : Allows the user to input and edit string values in a column's rows by typing directly into cells in the DAS grid. This comment capability is available for Private and Public reports and can apply to detail, subtotal, or grand total row levels.
• 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.