PICK$(list$, delimiters$, n)

 

Returns a String Value
Returns the nth substring from list$ that is separated by a character in the delimiters$ string (does not trim leading or trailing spaces).

Examples:

PICK$("Doe/John M.", "/", 1)

Returns "Doe".

PICK$("Tom Smith", " ", 1)

Returns "Tom".

PICK$("Doe/John M.","/",2)

Returns "John M.".

PICK$("Doe/John M.","/",3)

Returns "".

PICK$(DATE$(DATE), "-/", 3)

Returns the year "2026" assuming the current system date is "09/02/2026".

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)

 

See also:

TOKENIZE$( )