Q:

I want to get characters out of a string in Crystal Reports

How can i write this SQL formula in Crystal Reports?
SUBSTRING(text, 6, 4)) 

Sample String:  A003-A113-02
Using SUBSTRING in SQL, output = A113
Tried to use the Trim function, but not getting any good result.

A:

Trim removes whitespace-characters at the beginning and end of the string.
The equivalent of the SQL SUBSTRING-function in Crystal Reports is the Mid-Function:
Mid("A003-A113-02",6,4)

