This filter is used to remove 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 also removed. 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.

Remove Fields

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

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

Note - if you are removing more than one field range, it is easiest to remove ranges from right-to-left so that the position of the fields doesn't change.

See also

Remove menu
Remove columns

 Contact Us   Support   Community   Tutorials and User Guides (online)
 Copyright © 1999-2006 DataMystic. All rights reserved.