Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1275.Text file parser -- How to extract the forth column in the second line from different files?

User: shanfeng -- 2015-01-03          << 1274  1276 >>
Hits: 1615
Type: Text file parser   
Search all Text file parser examples
Description:
How to extract the forth column in the second line from different files into the same file?
Input Sample:
file1:a,b,c,d
      1,2,3,4
file2:a,b,c,d
      2,3,5,6
Output Sample:
file2:4,6
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. open "Tools->Batch Runner" menu
2. drag multiple files to "Batch Runner" window
3. click "Fast Replace" button
4. click "Add" to add new rules:
* leave "search" to be blank
* set "replace" entry to: 
* click "ok"
5. make sure "reg exp" and "Cross Line" options are checked, and click "start"
6. select "output to single file" option, done.

Screenshot 1:  Fast_Replace_Window


Similar Examples:
How to replace certain column from different files?  (67%)
How to extract and remove common lines from multiple files? (67%)
How to remove first 8 rows and extract column 5 and 8 into different files? (66%)
How to extract specified lines in different section of text file? (65%)
How to extract the second column from a database text file? (65%)
How to extract the last non-blank line from multiple text files? (64%)
How to extract column 3,6,7,8 from each line of text? (64%)
How to merge columns of 2 files with the same name in different folder? (62%)

Check Demo of Text file parser
Keywords:
leave  second line  output to single file  rules  blank  same file  same  different files  second  cross line  extract different files  replace multiple words in single file  multiple different words  extract same line  extract the same line  add different lines  column blank  extract words to column