Type: Option

The substring that is retrieved from CommaString.

SELECTSTR treats string values as OPTIONS. This means that identical values in different strings are not allowed.

Any trailing commas are removed before the operation begins.

If Number is less than 1 or greater than the number of real values (excluding trailing commas) in the string, then an error is returned.

Quotes are not supported. For example, a,b,"c,d",e is treated as a five-element substring where substring 4 is d".

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
CommaStr := Text000; CommaStr2 := Text002; SubStr1 := SELECTSTR(2, CommaStr); // Pick out the 2nd substring SubStr2 := SELECTSTR(4, CommaStr); // Pick out the 4th substring SubStr3 := SELECTSTR(1, CommaStr2); SubStr4 := SELECTSTR(3, CommaStr2); MESSAGE(Text001 + '>%1<\' + '>%2<\' + '>%3<\' + '>%4<\', SubStr1, SubStr2, SubStr3, SubStr4);

The message window displays the following text:

The calls to SELECTSTR return:

>is a comma<

>string<

>11<

>33<

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
CommaStr2 := Text002; SubStr5 := SELECTSTR(6,CommaStr2); MESSAGE('>%1<\', SubStr5);

This example returns an error.

Reference