Gareth Horton
July 12th, 2002, 02:54 PM
Joel Heyman wrote:
> I need to filter on a field that sometimes has a ? in it and sometimes has other data. How do I filter data that has a ? question mark in it and not have monarch recognize it as a wildcard?
Hi Joel,
The best way I have found to work with Wildcards is to use their ASCII character value.
For your needs, I would first create a calculated field to identify which cells contain the Wildcard using:
If(Instr(Chr(063),Field),Field,"")
This expression will create a Calculated Field that will populate cells that contain the wildcard character "?", and leave the other cells blank.
I would then create the Filter based on the new Calculated Field:
[New Field]<>""
I hope this is helpful,
DEE
> I need to filter on a field that sometimes has a ? in it and sometimes has other data. How do I filter data that has a ? question mark in it and not have monarch recognize it as a wildcard?
Hi Joel,
The best way I have found to work with Wildcards is to use their ASCII character value.
For your needs, I would first create a calculated field to identify which cells contain the Wildcard using:
If(Instr(Chr(063),Field),Field,"")
This expression will create a Calculated Field that will populate cells that contain the wildcard character "?", and leave the other cells blank.
I would then create the Filter based on the new Calculated Field:
[New Field]<>""
I hope this is helpful,
DEE