TheEntertainer
MIS
Morning all,
I've been asked by a colleague to write an exception report. This is a type of report we run that helps to check that all the data that should appear on the client report does. The exception report that they want however is a report which checks the make up of a string, which should be 8 characters long (which is easy enough) but the first 2 characters should be numbers, the next 3 letters and the final 3 number ie 00LLL123, but it could be any numbers or letters. How do I test for this?
I'm using Crystal 8 (although the people who will be running the report have 7) on an Oracle 7.3 database
Thanks in advance.
TheEntertainer
I've been asked by a colleague to write an exception report. This is a type of report we run that helps to check that all the data that should appear on the client report does. The exception report that they want however is a report which checks the make up of a string, which should be 8 characters long (which is easy enough) but the first 2 characters should be numbers, the next 3 letters and the final 3 number ie 00LLL123, but it could be any numbers or letters. How do I test for this?
I'm using Crystal 8 (although the people who will be running the report have 7) on an Oracle 7.3 database
Thanks in advance.
TheEntertainer