Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Configuration Management System (CMS)2018.05

Use > Data Flow Management > Universal Discovery > Inventory Discovery > How to Set Extract Options

How to Set Extract Options

All calculated asset fields defined can be set up so that only part of the string is selected instead of the entire string. They can also be set up, for example, to use the last part rather than the first part of the string. This can be useful for obtaining the last part of a calculated field that is too long.

Various other settings for manipulating the field contents are also available.

To set extract options:

After you have selected the field data type, click Extract. The button is only enabled for those field that are calculated. This option is not available for user-entered fields. The Asset Field Extract Options dialog box is displayed.
In the Extract Characters From group box, specify whether you want to use the last part or the first part of the string. Select one of the following options:
- Start - Uses the first part of the string. Use the arrows next to the Skip characters box to specify how many characters are to be skipped from the beginning of the string.
- End - Uses the last part of the string. Use the arrows next to the Skip characters box to specify how many characters are to be skipped from the end of the string.
For example, ABCDEF123. If you select End and skip 4 characters, the result is ABCDE.
In the Options group box, select the options as follows:
- Convert to Upper Case- Select this option to convert the alphabetic characters to upper case, if required.
- Treat Field as a File Name- Select this option to treat the string in the asset field as a file name.
Some characters are invalid in file names, so any invalid characters can be replaced with the character specified in the Replace Invalid Characters With box. For example, underscore (_) is a valid file name character and can be used to replace invalid characters.

If you select the Delete Invalid Characters option then any invalid characters are deleted.
If the extracted field is empty or is not found, then a default value for the string can be specified in the Default Value box. For example, if the text string Not Found is entered in this box, then an empty field or a field that has not been found is assigned this default value.

Related Information

Send Help Center feedback