Menu
Splits a text string into a table of substrings.
-->
Description
The Split function breaks a text string into a table of substrings. Use Split to break up comma delimited lists, dates that use a slash between date parts, and in other situations where a well defined delimiter is used.
A separator string is used to break the text string apart. The separator can be zero, one, or more characters that are matched as a whole in the text string. Using a zero length or blank string results in each character being broken out individually. The matched separator characters are not returned in the result. If no separator match is found then the entire text string is returned as a single result.
On your Mac, move the pointer to the green button in the top-left corner of the window, then choose Tile Window to Left of Screen or Tile Window to Right of Screen from the menu that appears. On the other side of the screen, click the second app you want to work with. In Split View, do any of the following.
Use the Concat function to recombine the string without the separators.
Use the MatchAll function to split a string using a regular expression.
The examples show how Split can be used with the First and Last functions to extract a single delimited substring. The Match function is often a more concise and powerful choice for those familiar with regular expressions.
Syntax
Split( Text, Separator )
ExamplesBasic usage
Different delimiters
Mac Split AppSubstring extractionMac Split App Isnap Vs Android
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |