Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1464.Text data calculation -- How to calculate one column base on value of another column?

User: kylelau -- 2022-01-22          << 1463  1465 >>
Hits: 795
Type: Text data calculation   
Search all Text data calculation examples
Description:
how to calculate acquire_sp * 10 according to level?  
like i just wanna calculate acquire_sp when level=1.or just according level to   
calculate other sections[unswing]..coz one line data include lots sections... 
Input Sample:
npc_begin warrior 20001 [gremlin] level=1 acquire_exp_rate=29 acquire_sp=2 unsowing=0...  
npc_begin warrior 20002 [rabbit] level=1 acquire_exp_rate=29 acquire_sp=2 unsowing=0...  
npc_begin warrior 20003 [goblin] level=5 acquire_exp_rate=7.12 acquire_sp=5 unsowing=0...  
npc_begin warrior 20004 [imp] level=6 acquire_exp_rate=5.9167 acquire_sp=6 unsowing=0..
Output Sample:
npc_begin warrior 20001 [gremlin] level=1 acquire_exp_rate=29 acquire_sp=20 unsowing=0  
npc_begin warrior 20002 [rabbit] level=1 acquire_exp_rate=29 acquire_sp=20 unsowing=0  
npc_begin warrior 20003 [goblin] level=5 acquire_exp_rate=7.12 acquire_sp=5 unsowing=0  
npc_begin warrior 20004 [imp] level=6 acquire_exp_rate=5.9167 acquire_sp=6 unsowing=0
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' dialog 
* set 'replace unit' to 'Line' 
* set 'search for pattern' to: 
 
* set 'replace with pattern' to: 
 
3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to calculate sum value of every column? (74%)
How to merge the data of second column base on value of first column? (70%)
How to calculate the absolute average value of every 2 columns? (69%)
How to calculate sum of every column and keep original columns? (63%)
How to calculate the minimum and maximum value in each line of text? (58%)
How to update values in xml file according to values from another xml? (57%)
How to calculate md5 hex value of each line of text file? (57%)
How to calculate the summaries of different EMA based on close values in stock? (57%)

Check Demo of Text data calculation
Keywords:
level  include  var  calculate  calculation  acc  calcu  calculat  line data  data  calculate 15  how to calculate 15  search calculate replace  search replace calculate  data base  replace another  another file  calculate text data