Function reference
Returns a value form a delimited string based on an index

IndexValue( sourcestring , delimiterstring, indexnumber)

Argument Description
sourcestring The list of values
delimiterstring The string that seperates the values in the sourcestring
indexnumber The numeric index of the values to retrieve

data type: String

Example 1
This expression returns c
IndexValue(‘a#b#c#d’, ‘#’ , 3)

Example 2
This expression returns “empty string”
IndexValue(‘a#b#c#d’, ‘#’ , 0)

Example 3
This expressions returns e
IndexValue(‘aXXbXXcXXdXXe’, ‘XX’ , -1)

Example 4
This expressions returns d
IndexValue(‘aXXbXXcXXdXXe’, ‘XX’ , -2)

Last modified: 23 May 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment