Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »



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

  • No labels