I am trying to parse data from a string column in Crystal Reports.
Attached screenshot will show how the data comes from the table. I need to get only the string that starts with "CD%". This number is always 12 characters.
Example I want the output to be
Please let me know how to get this accomplished. Thank you