Restrict to delimited fields (CSV, Tab, Pipe etc)

TextPipe: Online Help Restrict to delimited fields (CSV, Tab, Pipe etc)	Submit feedback on this topic
Home User Assistance Tutorials How to Use TextPipe Menus: File Edit Filters[ Wizards Convert Unicode Add Remove Replace Extract Special Maps Restrict ] Tools Window Help Advanced

Home
Up

This filter restricts sub filters to operate on a range of fields, delimited by a given character.

Choose the delimiter that separates your fields

You can choose a predefined delimiter character, or select your own. The trailing delimiter (if any) is included in the restricted text, so the entire field can be completely removed by using the Delete All filter as the sub filter (or you can use a Remove delimited fields (CSV, Tab, Pipe etc) filter). When Comma (.csv) is chosen, TextPipe automatically handles single and double quoted strings, with embedded line feeds.

First Row Contains Field Names

If the first line of the file contains Field Names, check this box so that TextPipe can count how many fields are expected. It can then determine if a field has embedded CR/LF characters and spans multiple lines. TextPipe can also determine this without a header if the fields are properly double-quoted - TextPipe will notice the missing double quote and continue reading the record from the following line.

Restrict Fields

Several different means of specifying the fields to restrict are provided:

Start field, end field. This removes all text including and between the specified fields.
Start field, width. Removes Width fields starting from (and including) field Start.
End field, width. Removes Width fields backwards starting from (and including) field End.
Start field to end of line. Removes all fields from the Start field to the very end of the line.
Width to end of line. Removes Width fields backwards starting from (and including) the last field.

Process fields individually

When this field is unchecked, the entire field range is returned as a single string. It is often easier for the sub filters to process each field individually, in which case it is checked, and the next two options apply.

Exclude column delimiter

When checked, this excludes any trailing delimiter from the restricted text, making it easier for sub filters to work with.

Exclude quotes (if present)

When checked, this excludes any surrounding quotes from the restricted text, making it easier for sub filters to work with.