KeyView 24.1

# Tab Delimited Output for Spreadsheets and Embedded Tables

You can use KeyView to convert spreadsheets, embedded tables in Word Processing documents (for example, Microsoft Word documents), and tables detected by Optical Character Recognition (OCR), to tab-delimited form.

In this format, KeyView inserts a tab character between each cell, and a line break between each row. Tab and line break characters in the cells are replaced with spaces. For spreadsheets, this format ensures that tabs exist between empty cells, which can be useful when you need to keep the table structure after filtering.

To enable tab delimited output for spreadsheets and embedded tables

- In the Java API, call the `setTabDelimited` method on the `filter` object, for example:

      filter.setTabDelimited(true);

- In `formats.ini`, set the following parameter. (This is an alternative approach - you do not need to do this if you have configured this feature through the API.)

      [Options]
      TabDelimited=TRUE

## Table Output for IDOL Eduction

For files that contain multiple tables, KeyView includes an option that creates output with delimiters between tables that can be understood by IDOL Eduction. This option allows Eduction to extract entity data from tables.

To use this option, you must enable Tab Delimited output, and set the target character set to KVCS_UTF8.

To enable table delimiters for spreadsheets and embedded tables

- In the Java API, call the `setOutputTableDelimiters` method on the `filter` object, for example:

      Filter.setOutputTableDelimiters(true);

- In `formats.ini`, set the following parameter. (This is an alternative approach - you do not need to do this if you have configured this feature through the API.)

      [Options]
      OutputTableDelimiters=TRUE

For more information about table extraction in IDOL Eduction, refer to the IDOL Eduction User and Programming Guide.

Copyright 2016-2023 Open Text
Version 24.1 | Last updated December 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL KeyView 24.1

Topic Title: Tab Delimited Output for Spreadsheets and Embedded Tables