Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

670.Text data calculation -- How to add some number to the specific column in csv file?

User: editor -- 2010-12-03          << 669  671 >>
Hits: 1685
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