Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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: 990
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