f$Splitstring (f$TextZerlegen)

This function decomposes a string into a field. The separator symbol or string can also be given if desired.

If parts of the string are included in ", then separator strings within this section are ignored. Should a " be present in the text, then this must be masked with itself (""). This function is well suited to processing files which have been written in CSV format (e.g. in Excel). If the separator string is not part of the string, then the entire string will be returned on the first field index.

Syntax:	Quantity = f$Splitstring( String , Fieldname , separator )
	Argument	Type	Meaning
	String	String	String to be processed
	Fieldname	String	Name of the indexed string parameter onto which the result is written. Instead of a 1-dimension parameter, a simple parameter from a 1-dimension parameter group can also be used.
	Separator	String	The separator symbol or separator string
Result:	Integer	Quantity of split part strings. If the field's dimensions are too small, a negative quantity is returned.
Example:	Text = '1,2,3"" (inches),"4 " , 5,6,"a,b",7' Quantity = f$Splitstring(Text,'PG[1].Name',',') Result: Quantity = 8 Field elements: 1 2 3" (inches) 4 followed by a space 5 6 a,b 7