| User: editor -- 2010-12-03 << 669 671 >> |
| Hits: 3219 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to add 10 to the the column D in csv file? |
| Input Sample: |
| 2,4,6,8,10 1,3,5,7,9 1,2,3,4,5 6,7,8,9,10 |
| Output Sample: |
| 2,4,6,18,10 1,3,5,17,9 1,2,3,14,5 6,7,8,19,10 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open csv file 2. ctrl-h open 'replace' window * set "replace unit" to "Word" * set "replace scope" to "Line" * set "unit number filter" to "4" means the 4th word in each line(column D) * set "replace with pattern" to: ** click "Settings" page * set "Input delimiter" to "other", and enter a comma in the following entry. 3. click "Replace", done. 4. ctrl-s save to csv file. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Settings_Window |
Similar Examples: |
| How to search and replace words in specified column in csv file? (69%) How to add a space at the specific location of each line? (67%) How to duplicate column A by the number of times in column B in csv file? (67%) How to delete line with specific columns in specific range? (66%) How to sort the text by the number of specific word in each line? (66%) How to search and sum the numbers at specified position in a text file? (65%) How to add a line number at the beginning of each line? (64%) How to delete last column in a csv file? (62%) |
Check Demo of Text data calculation |
| Keywords: |
| 4th specific calculation calcu calculat delimiter unit number filter number filter settings comma delimiter calculation replace specific comma replace specific word in in a specific column a file specific word add comma add delimiter add page number replace with specific |