Restriction Filters

Restrict line range

This filter restricts sub filters to operate on a range of lines. The lines can be selected by using an offset from the beginning or end of the file. All selected lines can be completely removed by using the Delete All filter as the sub filter. This filter can be used like a Unix head or tail filter.

Restrict column range

This filter restricts sub filters to operate on a range of columns. The columns can be selected by using an offset from the beginning or end of the line. All selected columns can be completely removed by using the Delete All filter as the sub filter. This filter can be made a sub filter of a Restrict line range filter.

If you're working with EBCDIC data, you should not use this filter, because EBCDIC data can contain embedded new line characters in packed or zoned decimal fields. Use the Restrict to Byte range filter instead.

Restrict matching lines (Grep)

This filter restricts sub filters to operate on lines that match a pattern or regular expression.

• Note: This filter allows you to use the regular expression characters, ^ and $.
• ^ match from the start of a line (or at the start of the file)
• $ match at the end of a line (or at the end of the file)

Restrict to Lines Matching
The string or pattern to find. The string can be found anywhere on a line. The right-click (or context) menu on this field supports Undo, Cut, Copy, Paste, Delete, Clear Entire Field, Select All and Select All And Copy, entering special characters and inserting pattern match characters.

Pattern type
Determines which style of pattern match to use. The default is to use powerful perl-style pattern matching, but you can also use newer and easier EasyPatterns, as well as Word-style and Brief-style patterns. Older egrep-style pattern matching is offered for backward compatibility.

Match Case
When checked, the case of the string found must be identical to the Match Pattern exactly.

Output Count of Matches
When checked, outputs a count of the number of matches in each file instead of the actual matches.

Include Filename
When checked, outputs the filename prior to showing the match information.

Include Line Numbers
When checked, shows the line numbers of each match with the match text.

Context Lines
Context Lines Before the Match
This option outputs context lines prior to the matching line. This can be very useful when you want to see the lines surrounding a matching line. Enter a value larger than 0 to determine the number of context lines to be output. TextPipe may not be able to output the desired number of context lines before the matching line if the matching line is near the start of the file. In this case TextPipe will output as many prior context lines as are available. Note also that if two subsequent lines match then the resulting output may be difficult to understand.

Context Lines After the Match
This option outputs context lines after the matching line. This can be very useful when you want to see the lines surrounding a matching line. Enter a value larger than 0 to determine the number of context lines to be output. TextPipe may not be able to output the desired number of context lines after the matching line if the matching line is near the end of the file. In this case TextPipe will output as many trailing context lines as are available. Note also that if two subsequent lines match then the resulting output may be difficult to understand.

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

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.