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)`

Service Manager

Administer > Database administration > Data persistence > Exporting records > Export a record list to a text file

Export a record list to a text file

Applies to User Roles:

All users

To export a record list to a text file:

Open a list of records. For example, open a list of open incident records.

Click Incident Management > Search Incidents.
Select Open status, and then click Search.

A list of incident records opens.

Note: You can click More or the More Actions icon and then click Modify Columns, so that only those columns containing data that you intend to export are displayed. You must keep the column that contains the key field.
From the record list, click More or the More Actions icon, and then choose Export to Text File.

Fill in the following fields.

Field	Description
Filename	Type, or browse to, the path and name of the new text file.
Comma Separated Value (CSV)	Select this option to use the comma character as a field delimiter.
Semicolon Separated CSV	Select this option to use the semicolon character as a field delimiter.
Tab	Select this option to use the tab character as a field delimiter.
Asterisk	Select this option to use the asterisk character as a field delimiter.
Caret	Select this option to use the caret character as a field delimiter.
Other	Select this option to use a designated character as a field delimiter. Type the character delimiter.

Do one of the following to save the file:
- For Windows clients:
  In the Filename field, specify a path and name for the text file, and then click OK.
- For Web clients:
  Click OK. Save the file when a download job starts in your Web browser.

Connect

Micro Focus Marketplace

ITSM Blog for IT Service Management

ITSM Community

Documentation Forum

Learn

Software Support Online

Software Support Downloads

Software Education Services

Contact

Submit Service Request

View Service Requests