case function with a wildcard??

[saranyc1]

Hello.

This seems simple, but I can't remember how one might do this.

I have a lot of records that need to be assigned IDs so as to relate them to records in another table. The trouble is that they are all spelled inconsistently and there are slight variations that would need the same assignation. I wanted to build a case function like this:

Case(

b_MatName = *"B&B"*, "038",

b_MatName = *"PVC"*, "044",

b_MatName = *"curb"* "012", "")

I've tried this both with and without the quotes and with the quotes in and outside of the asterisks.... no avail.

Any thoughts?

Thanks,

Sara

[David Jondreau]

Check out the function called PatternCount().

[saranyc1]

perfect, thanks!

[Genx]

Just a side note, the default option in your case statement is not necessary e.g. you can write it without that last empty string:

Case(

b_MatName = *"B&B"*, "038",

b_MatName = *"PVC"*, "044",

b_MatName = *"curb"* "012")