PhixFlow Help

substring



Function: substring()

Returns a portion of the supplied string between specified character positions.

Syntax

substring(string, startPosition, endPosition)

ArgumentTypeDescription
stringStringThe string to be processed.
startPositionIntegerThe character position to start the substring from.
endPositionIntegerThe character position to end the substring at. If not specified, the substring will default to the end of the string.

Examples

substring("01223236023",6,9)

Returns the portion of the string between character positions 6 and 9: "2360".


substring("01223236023",6)

Returns the portion of the string between character position 6 and the end of the string: "236023".


substring(in.fileName, indexOf(in.fileName, "_")+1, indexOf(in.fileName, "_")+9)

Suppose in.fileName contained file names with the format "switchRC48_20060708.exp" and we wish to retrieve the date from the file name.

The first, string portion of the file name is variable so we search for the "_" character with the function indexOf, and use the returned value in substring to pull out the date from the file name.

See Also

Please let us know if we could improve this page feedback@phixflow.com