wildcard in CableMatic

4 posts / 0 new
Last post
Offline
Joined: 04/01/2013 - 3:48pm
wildcard in CableMatic
Offline
Joined: 05/31/2012 - 9:19am

HC,

While there isn't much of an explanation in your post, I will try my best to answer...  "Wild Cards", or special characters, can be used in the 'DbQuery' filtering window in order to narrow the results of your selection.  The following wild card combinations can be used in the filter window:

* (Asterisk):  The * symbol can be placed in any filter and can be equated to 'Select All'.  Using the symbol alone will not limit the number of records in the query, but instead will retrieve all records from the database.  However, placing the symbol as at the beginning, or end, of a search term will instruct DbQuery to return all results that match.  For example, if I'm searching for a cable tag that begins with 'CAB-09', but I'm not sure of the last sequence of digits, inputting 'CAB-09*' will return all cables that start with 'CAB-09'; regardless of how the tags are ended.  By placing the asterisk on both sides of a value, for example *CAB-09*, the results will include all records that contain the value 'CAB-09'.

Not Like:  The words 'Not Like' can be added to a filter in conjunction with the asterisk (*) to retrieve all records that do not include the value entered.  For example... Not Like '*-001*' will return all records that do not contain -001 in the value.  Be sure to use two single quotes (apostrophes) and two asterisks (*) surrounding the value not wanted in the field... as shown in the example

? (Question Mark):  The question mark symbol can be used to replace any single character in a record when used as a filter.  For example, if there were a series of tags such as the following:

CAB-01, CAB-02, CAB-11, CAB-22, CAB-98.

Inputting 'CAB-??' will return all of the cables listed above... however inputting 'CAB-?1' will only return CAB-01 and CAB-11

<>'': Not Equal to Blank - By placing the not equal to blank symbols in the filter, DbQuery will only return records that have data in the field the search criteria is used.

< (Less Than):  The less than symbol can be used like '< 50', and will return all records with a value less than 50

> (Greater Than):  Much like less than, greater than is much like less than, only in the opposite context.  For example, > 18 will return all records with a value greater than 18

'' (Two Single Quotes (Apostrophes)): Blank:  Using the symbol for blank DbQuery will only return records from the database that are blank in the field the symbol is used in.  

BLANK: typing the word blank in the filter will produce the same results as two single quotes

In addition, more examples of wild cards can be found by navigating to 'Help > Database' from the Spreadsheet section of the program.

Hope that helps...

GSN

Offline
Joined: 04/01/2013 - 3:48pm

Ah, sorry. It seems that somehow my post didn't post. I am unable to use the wildcard * when using the find/replace feature in CableMatic.

Offline
Joined: 05/31/2012 - 9:19am

CARS is not programmed to understand the * wildcard in the Find/Replace function.  If you would like this to be a functionality, please submit a formal request in the form of an email to the GSN Technologies team at Support@GSNTechnologies.com and we will add it to the maintenance schedule.

Thank you for your understanding.

GSN Technologies

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
By submitting this form, you accept the Mollom privacy policy.