If field equals *NAME make it summaries into "#NAME" 1

[willz99ta]

Hi and thanks,

I have a field that could be (written with wildcards) *BUSINESS CARD*

I am trying to count and summarize all items with this description along with the #BUSINESS CARDS item names.

Background:
The problem is that some jokers were allowed to make their own entries and made item names like #BUSINESS CARD JOE SCHMOE. I am trying to grab the thousands of these entries and summarize them with the correctly entered #BUSINESS CARDS

Thanks for your help,
Will

 

[lbass]

What have you tried?

ucase({table.field}) like "*BUSINESS CARD*"

...should work as a record selection formula. Remove the ucase() if the field is always in upper case. If case can vary, it would actually be better to create a SQL expression {%field} like:

{fn ucase(`table`.`field`)}

...and then use a record selection formula like:

{%field} like "*BUSINESS CARD*"

-LB

 

[willz99ta]

Well, I am trying to have it summarized while also summarizing other items (so I didn't use the record selection). For example: other item names like "LBL CUT" are working fine, it's just the business cards that need to be grouped like this?

Impossible?

 

[lbass]

if ucase({table.field}) like "*BUSINESS CARD*" then
"Business Card" else
{table.field}

If I'm understanding you, insert a group on this formula.

-LB

 

[willz99ta]

LB Strikes Again