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
663.Text data calculation -- How to calculate the summaries of every line in a txt file?
User:
Lynne -- 2010-11-23
<< 662
664 >>
Hits:
3603
Type:
Text data calculation
Search all
Text data calculation
examples
Description:
How to calculate the summaries of every line in a txt file?
Input Sample:
1 2 3 4 5..100
2 4 6 8 3..999
4 6 7 9 2..876
There are 1000 columns in one file.
Output Sample:
How to calculate SUM of every line like Excel?
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' entry to:
join(' ',add(@match[1..$max-1]))\n
or
join(' ',add(split('\s+',$match)))\n
3. click 'Replace', done!
Screenshot 1: Replace_Window
Similar Examples:
How to calculate summary of every column in a text file?
(87%)
How to calculate md5 hex value of each line of text file?
(72%)
How to delete duplicate numbers in every line in text file?
(71%)
How to replace the second character of every line to 4 in a text file?
(69%)
How to calculate sum value of every column?
(68%)
How to calculate the minimum and maximum value in each line of text?
(67%)
How to delete the first word in each line in a text file?
(64%)
How to calculate each number in a line with different formula?
(63%)
Check Demo of
Text data calculation
Keywords:
max
ies
calculate
calculation
calcu
calculat
every line
every
data
very
calculate text data
calculation in text file
line data
replace line data
replace with data
replace every
data replace
replace with txt