|User: editor -- 2010-12-03 << 669 671 >>|
|Type: Text data calculation|
|Search all Text data calculation examples|
|How to add 10 to the the column D in csv file?|
|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
|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
|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|