Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

302.Text data calculation -- How to make subtraction on 2 columns of CSV file, and save it to TXT format?

User: editor -- 2008-12-04          << 301  303 >>
Hits: 2151
Type: Text data calculation   
Search all Text data calculation examples
Description:
How to make subtraction on 2 columns of CSV file, and save it to TXT format?
Input Sample:
"1000","1003","AC"
"1004","1009","AD"
"1011","1028","DA"
Output Sample:
1000 3 AC
1004 5 AD
1011 17 DA
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o to open CSV file.
2. ctrl-h open "Replace" dialog.
* set "Replace Unit" to "Line"
* fill in "Replace with Pattern" to:


select "settings" page:
* set input delimiter to "other", and fill as:


3. Click "Replace", done!

Note:
* words($match,2) means the 2nd word
* calc(words($match,3)-words($match,2)) means the subtraction of 3rd and 2nd word
* \n means newline
* [\"\,] means word is separated by quotaion or comma.
Download Script:  scripts/302.rst.zip

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Settings_Window


Similar Examples:
How to convert a duration of seconds to a time format? (57%)
How to make multiple copies of a file and rename them from a list? (57%)
How to merge columns of 2 files with the same name in different folder? (56%)
How to merge two columns of a CSV file? (56%)
How to make column merge for files in two folders? (55%)
How to make math calculation on columns and generate a new column of result? (54%)
How to replace the second column of a file with an increasing number? (53%)
How to extract and join text from multiple files with user defined format? (53%)

Check Demo of Text data calculation
Keywords:
subtracti  subtraction  how to make subtraction  subtract  3rd  newline  quot  2nd  separate  calculation  delimiter calculation  to delimiter  by word  file format  other file  page 1  file with word  word file