Building Your Event-Driven Architecture : Working with My webMethods : Searching for Data : Working with Search Results : Exporting Search Results to a .csv File
Exporting Search Results to a .csv File
You can export search results to a a comma-delimited text file (.csv file) if the search results panel includes the Export Table function.
The Export Table function exports columns that are hidden (data-only) or rendered on the screen when those columns are marked as exportable. Columns that are not rendered on the screen are omitted from the output, even when they are marked as exportable.
After exporting search results to a .csv file, you can then import the .csv file into Microsoft Excel, Microsoft Access, or any other application that accepts the .csv file format.
To export search results
1. Click Export Table, which is located in the top right of the search results.
2. From the Character Encoding list, select the character encoding to use.
3. Click Export.
4. Click Save to indicate you want to save the search results to a file.
5. In the Save As dialog box, browse to the location where you want to save the .csv file.
6. Click Save.
Note:  
To open a .csv file saved with UTF-16 LE encoding in Excel 2000 or earlier, you will need to import the file using Data > Get External Data > Import Text File and follow the instructions in the Import Wizard.
Copyright © 2016 - 2016 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback