Basic Pattern Analysis
Pattern Matching
Pipe operator
Remove Leading/Trailing Whitespace
Run basic pattern analyses on character sets, digits, or combined input containing both characters and numeric digits. Useful for data cleaning and for identifying columns containing multiple or nonstandard formats.
Useful links