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
661.Text data calculation -- How to multiply column in one file with multiple columns in another?
User:
Lynne -- 2010-11-22
<< 660
662 >>
Hits:
3151
Type:
Text data calculation
Search all
Text data calculation
examples
Description:
How to multiplicate many columns which in diffcult files?
Thank you!
Input Sample:
001.TXT
1
2
3
002.TXT
1 2 3..
1 4 3..
1 5 6..
Output Sample:
003.TXT
1*1 1*2 1*3..
2*1 2*4 2*3..
3*1 3*5 3*6..
Do multiplication.
Answer:
Hint: You need to
Download and install "Replace Pioneer"
on windows platform to finish following steps.
Assume first file is c:\001.txt, second file is 002.txt
1. ctrl-o open the second file 002.txt
2. ctrl-h open 'replace' window
* in 'search for pattern', enter:
\d+
* in 'replace with pattern', enter:
calc($match* file_line('001.txt',$global_line_no,'c:\\'))
3. click 'Replace', done.
4. ctrl-s save to a file.
Screenshot 1: Replace_Window
Similar Examples:
How to delete the 4th column from text files with 8 columns?
(61%)
How to fill in one xml file with elements from another xml file?
(60%)
How to extract the 7th column from text files with 8 columns?
(58%)
How to sort all the lines of a text file by order the multiple columns?
(58%)
How to merge more columns into one column in multiple csv files?
(57%)
How to count the index page size of multiple web sites?
(56%)
How to duplicate column A by the number of times in column B in csv file?
(56%)
How to exchange column 2 and column 3 in multiple csv files?
(55%)
Check Demo of
Text data calculation
Keywords:
multiplicate
global
multiply
calculation
calcu
calculat
columns
second
data
ass
multiply column data
multiple replace one file another file
multiply file
first columns
replace with multiple data
replace another
second column
another file