I am attempting to write a report in Crystal 9 that will show all items that are enclosed in brackets, ([ ]) in a memo field. I find that when I try to use Select Expert that the field is not available. I then tried to write a formula with no success. I thought this would be simple as it is only one table that I am looking at.
Perhaps it would be helpful if I gave the purpose. We create standard work for items that we manufacture. The items call for specific specifications. We enclose these specification call outs in brackets which lets the system know to look in the specification library and automatically assign it the latest revision. I need to get a list of all these specifications that have been enclosed in brackets. ANY help with this would be most helpful.