Replace Pioneer Home
All Examples
Free Download
all
Advanced search and replace
Replace text in multiple files
Regular expression replace
Batch file rename
Batch download
Text file parser
Text file splitter
Html text generator
Search replace binary
Random word generator
Count and statistics
Character encoding
Bin Hex Oct Dec converter
Text generator
Text sort
Text merge
Text data calculation
RSS: Replace Pioneer Examples
677.Text data calculation -- How to add a column which is the summary of column 3,4 and 6 in text file?
User:
editor -- 2010-12-13
<< 676
678 >>
Hits:
3316
Type:
Text data calculation
Search all
Text data calculation
examples
Description:
How to add a column which is the summary of column 3,4 and 6 in text file?
Input Sample:
* * 3 4 * 6 * *
* * 1 8 * 9 * *
* * 2 7 * 8 * *
Output Sample:
* * 3 4 * 6 * * 13(=3+4+6)
* * 1 8 * 9 * * 18
* * 2 7 * 8 * * 17
Answer:
Hint: You need to
Download and install "Replace Pioneer"
on windows platform to finish following steps.
1. ctrl-o open source text file
2. ctrl-h open replace window
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:
$match add($match[3],$match[4],$match[6])\n
3. click 'Replace', done!
For multiple files, click "Batch" in step 3, and drag multiple files to "Batch Runner" window, click "Batch Replace", done!
Screenshot 1: Replace_Window
Similar Examples:
How to calculate summary of every column in a text file?
(65%)
How to add a blank line after every 8 lines in text file?
(58%)
How to Random insert one or three line to a text file?
(56%)
How to exchange column 2 and column 3 in multiple csv files?
(56%)
How to delete all columns with more than 8 words in text file?
(55%)
How to add a page number after every 40 lines in a text file?
(55%)
How to extract all odd columns 1,3,5,... from a text file?
(55%)
How to change columns in each line to specified order in text file?
(54%)
Check Demo of
Text data calculation
Keywords:
summary
calculation
calcu
calculat
add a column
data
calc
sum
step
cal
add replace data in multiple files
replace with multiple data
calculation in text file
replace text in files open source
replace in files open source
add column
replace with data
data replace