Replace Pioneer Home All Examples Free Download

1222.Text file parser -- How to extract line if the 1st column is "a2" and the 2nd column is "b2"?

User: shanfeng -- 2014-07-30 << 1221 1223 >>

Hits: 2995

Type: Text file parser

Search all Text file parser examples

Description:

How to extrace line with special words if the first column is "a2" and the second column is "b2"?

Input Sample:

a1 b1 3 4 5 6
a2 b2 5 6 7 8
a3 b3 5 6 7 8
a4 b4 6 7 8 9

Output Sample:

a2 b2 5 6 7 8

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'If' to:

3. click 'replace', done.
4. ctrl-s save to file.

Screenshot 1: Replace_Window

Similar Examples:

How to extract the 7th column from text files with 8 columns? (63%)
How to extract the first and last lines where the second column is the same? (58%)
How to remove lines where the last column does not match column 4? (56%)
How to extract the forth column in the second line from different files? (56%)
How to delete the 4th column from text files with 8 columns? (56%)
How to extract all lines that contain words in a list? (55%)
How to extract lines with specific words in first column? (55%)
How to extract all lines that contain "abc" from multiple files? (54%)

Check Demo of Text file parser

Keywords:

1st special 2nd second column first column second extract line text file parser file parser parser extract 1st line extract first column extract 2nd line extract words to column first and second words special text 2 extract column extract the first line