| User: editor -- 2008-12-04 << 301 303 >> |
| Hits: 4482 |
| 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 |