Splits a string into many strings.
string SPLIT(string value, string splitChar) string SPLIT(string value, string splitChar, int index)
|value||String||The original string to look in.|
|splitChar||String||The character that splits the strings.|
|index||Integer||The item index to return.|
You have an array of email addresses separated by a "|" but want these separated:
Will return "firstname.lastname@example.org; email@example.com; firstname.lastname@example.org".
You have an array of products separated by a "|" but only want to return the second product in the list:
Will return "Ouvvi".
This could be used to gather the domain from an email with the combined use of the ARRAYINDEX function:
Will return 'simego.com'.
This can be used to return the company name from an email address:
SPLIT((SPLIT("email@example.com,"@",2)), ".", 1)
Will return "simego".