This function will split up a text string based on a character you specify and then return the number of delimeter separated values
Sample Input:
splitSize( “tom|jane|mary”; “|” )
Sample Output:
3
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
/* // splitSize ( string; delimiter ) // Splits a string based on a character delimiter and returns the number of values Sample Input: splitSize( "tom|jane|mary"; "|" ) Sample Output: 3 Description: This function will split up a string based on a character you specify and then return the number of delimeter separated values. Author: Tami Williams www.asktami.com info@asktami.com */ Let ( [ valueList = Substitute ( string ; delimiter ; "¶" ) ] ; ValueCount ( valueList ) ) |