Search code examples
crystal-reportssubstringtrim

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.

Solution

  • 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)