SUBSTRING$(string_exp$, start_pos) SUBSTRING$(string_exp$, start_pos, n)

 

Returns a String Value
Returns a string n characters long consisting of characters copied from string_exp$ beginning at the character specified by start_pos. If n is not specified (in the alternate format), characters are copied from start_pos to the end of string_exp$.

Examples:

SUBSTRING$("John Q. Public", 6, 1)

Returns "Q".

SUBSTRING$("John Q. Public", 6)

Returns "Q. Public".

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:

MID$( )