| User: editor -- 2008-12-04 << 301 303 >> |
| Hits: 593 |
| 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 make column merge for files in two folders? (55%) How to extract and join text from multiple files with user defined format? (53%) How to extract titles of all html files and save them to one file? (53%) How to append the second columns of file A and B if first columns are identical? (52%) How to convert a text file to specified format? (50%) How to extract tables from html files into csv file automatically? (50%) How to add MACD, EMA, FAST%K, SLOW%D columns for CSV file of stock data? (50%) How to parse data from the text file and create text with user specified format? (50%) |
Check Demo of Text data calculation |
| Keywords: |
| subtraction how to make subtraction subtracti subtract newline 2nd sub delimiter calculation columns delimiter calculation file format other file file with word word file 1 1 |