Finding "**" in Customer Name 1

[BryanLane]

I have a customer database where they have inserted a pair of asterisks in the Customer Last Name field if the customer has a resale certificate on file with us. This was done to make it easier for our counter staff to see at a glance that one was present.

The customer's name will appear as "Joe Blow **" if the certificate is on file and just "Joe Blow" if one is not on file. It may not be the last two characters because they may put other items in the name as well like "(Cash)" or "(COD)" or a specific job location. There is no consitency in the order, some end just "**", some end "** (Cash)" some end "(CASH) **"

I want to find all those that have "**" anywhere in the in the Last Name field. I am using CR XI (11.5.8.826).

"The problems we face today cannot be solved by the minds that created them."
--Albert Einstein

 

[fisheromacse]

You could use a formula like this:

//@findchar
if instr({TABLENAME.FIELDNAME},"**") >0 then "true" else "false"

Then display only the 'true' records.

 

[BryanLane]

Thank You very much. That did the trick.

Have a great day.

Bryan

"The problems we face today cannot be solved by the minds that created them."
--Albert Einstein

 

[CoSpringsGuy]

use that formula in your record selection

instr({TABLENAME.FIELDNAME},"**") >0

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[BryanLane]

Thanks CoSpringGuy.

"The problems we face today cannot be solved by the minds that created them."
--Albert Einstein