This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The option to be able to search a field with wildcard characters is often needed. This functionality within the Calgary suite of Tools can be accomplished by having a “Contains” function, where this is accomplished without utilizing a wildcard to search. This also allows you to be able to use the Indexing power that the Calgary products offer, without having to do these searches with downstream functions like Filter or other Formula based tools.
Here's how 1) Create a base cydb file with this option selected:
2) Once the base file has been created, you now want to modify that cydb file to enable the Fields you want to query with the “Contains” option. In this example dataset, we want to be able to do these type of queries for the “CONAME” and “ADDR” fields:
Setup Calgary Input into Calgary Loader, when the following message will appear. Make sure you check “Yes”
3) Select the “Load a single advanced index” option
Set the Index Name you would like (in this case, keeping the same name), and choose the field desired from the “Source Field”.
Also, set Advanced Index Mode to Full Text
4) Repeat this process with all of the fields you’d like to be able to search. In this sample, placing “mail” in the CONAME and “ln” in the ADDR fields returned this record: