Formula | Description | Result |
---|---|---|
Split( 'Apples, Oranges, Bananas', ',' ) | Splits the different fruits apart, based on the comma separator. The split is performed based on only the comma and not the space after it, resulting in a space at the front of ' Oranges' and ' Bananas'. | |
TrimEnds( Split( 'Apples, Oranges, Bananas', ',' ) ) | Same as the previous example, but in this case the space is removed by the TrimEnds function, operating on the single column table that is produced by Split. We could have also used the separator ', ' which includes the space after the comma, but that would not have worked properly if there is no space or there are two spaces. | |
Split( '08/28/17', '/' ) | Splits the date apart, using a forward slash as the separator. |
Formula | Description | Result |
---|---|---|
Split( 'Hello, World', ',' ) | Splits the words apart, using a comma as the separator. The second result starts with a space since this was the character immediately following the comma. | |
Split( 'Hello, World', 'o' ) | Splits the string apart, using the character 'o' as the separator. | |
Split( 'Hello, World', 'l' ) | Splits the string apart, using the single character 'l' as the separator. Since there were no characters between the two l's in Hello, a blank value was returned. | |
Split( 'Hello, World', 'll' ) | Splits the string apart, using the double character 'll' as the separator. | |
Split( 'Hello, World', '%' ) | Splits the string apart, using the percent sign as the separator. Since this separator does not appear in the string, the entire string is returned as one result. | |
Split( 'Hello, World', ' ) | Splits the string apart, using an empty string as the separator (zero characters). This will break the string on each character. |
Formula | Description | Result |
---|---|---|
First( Split( Last( Split( 'Bob Jones <[email protected]>', '<' ) ).Result, '>' ) ).Result | Splits the string apart based on an opening delimiter (<) and extracts the string to the right of the delimiter with Last. The formula then splits that result based on the closing delimiter (>) and extracts the string the left of the delimiter with Right. | '[email protected]' |
Match( 'Bob Jones <[email protected]>', '<(?<email>.+)>' ).email | Performs the same delimiter based extraction as the last example but uses the Match function and a regular expression instead. | '[email protected]' |