Vanguard Software
Forecasting & Planning Solutions

contents.gifindex.gifprev1.gifnext1.gif

tolist

Format: tolist( text, sep )

Arguments: (text) text Input text string

[text] sep Optional list of possible separators; default = ","

Returns: [text] List of text fragments created by breaking text into parts delimited by any string in the list sep

Description: Tolist converts a text string into a list of substrings. A new substring is created every time any one of the delimiters in sep is encountered.

Examples: tolist("A text string"," ") = [A,text,string]

tolist("1; 2; ; Some Text; 3.14","; ") = [1,2,,Some Text,3.14]

tolist("a b; c d",["; "," "]) = [a,b,c,d]

count(tolist(txt," ")) = counts the number of words (delimited by spaces) in txt

See Also: tostring, tonumber, eval

  Forecasting Software  |  Strategic Planning Software  |  Decision Support Software
Decision Tree Software  |  Monte Carlo Simulation Software  |  Risk Analysis Software
Portfolio Analysis  |  Expert System Software  |  Market Research Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2009 Vanguard Software Corporation
Home Products Solutions Services Customers Partners Company
Vanguard
Applying science to business management
Vanguard
Print this page   Email this page to a friend