| User: editor -- 2010-12-03 << 669 671 >> |
| Hits: 379 |
| 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 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 add filename as a new column for multiple csv/txt files? (60%) How to change the number in each line to specified order in a text file? (60%) |
Check Demo of Text data calculation |
| Keywords: |
| 4th specific delimiter calculation calcu unit number filter number filter csv settings comma replace specific comma delimiter calculation add comma replace with specific add page number scope filter replace word with data replace column csv |