INFOR.SPLIT_VALUE

This function returns a portion of a string, based on a separator within the string. It is used to return a component of a string. For example, a multi-part customer account value is 001-324-26358213.

Use the split value function to return only the third component, 26358213. The first parameter is the separator to locate in the string. The second parameter is the component. Component numbers 0 and 1 both return the first component of the string. The third parameter is the string to return based on the position of the separator in the string.

Syntax

infor.split_value('separator',component,string_expression)

Example

infor.split_value('-',3,'001-324-26358213')

Result

26358213