Replace Pioneer Home All Examples Free Download

1139.Advanced search and replace -- How to divide each column by the first number?

User: Lynne -- 2013-09-28 << 1138 1140 >>

Hits: 3149

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

I want each column divided by the first number,how to calculate it?

Input Sample:

2013-01-01    2    4    8   10
2013-01-02   60   80   90   80
2013-01-03  110  120  130  140
.
.
.

Output Sample:

2013-01-01    2/2    4/4    8/8   10/10
2013-01-02   60/2   80/4   90/8   80/10
2013-01-03  110/2  120/4  130/8  140/10
.
.
.

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Word'
* set 'replace scope' to 'Line'
* set 'replace with pattern' to:
* click 'advanced' tab,
set 'run following for each matched unit' to:

3. click 'replace', done.

Screenshot 1: Replace_Window

Screenshot 2: Replace_Advanced_Window

Similar Examples:

How to replace the second column of a file with an increasing number? (64%)
How to merge remaining columns into the first column? (62%)
How to delete last column in a csv file? (59%)
How to delete the 4th column from text files with 8 columns? (58%)
How to extract the 7th column from text files with 8 columns? (57%)
How to merge other columns one by one into the first column? (56%)
How to change each number to an increasing number starting from 8? (56%)
How to remove duplicate column in each line? (55%)

Check Demo of Advanced search and replace

Keywords:

divide div calculate calcu calculat replace scope scope calc run following for each matched unit tab divide number search calculate replace search replace calculate search by column first column replace number column search by number first match