Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1462.Advanced search and replace -- How to set different replace method based on specific word?

User: Jiang nan -- 2021-12-30          << 1461  1463 >>
Hits: 788
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
how to set different replace method based on specific word in the same line. If  
the word is "decimal  
or number", then remain decimal place, else not.  
Thank you. 
Input Sample:
c1 varchar xxx 10  
c2 decimal xxx 12 2 
c3 number xxx 13 2 
c4 varchar2 xxx 8 0 
c5 number xxx 13 
Output Sample:
c1 varchar(10), 
c2 decimal(12,2), 
 
c3 number(13,2), 
c4 varchar2(8), 
c5 number(13,0)
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source file 
2. ctrl-h open 'replace' dialog 
* set 'replace unit' to 'Line' 
* set 'replace with' 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 search and replace text base on csv file column 1 and 2? (57%)
How to search and replace words in specified column in csv file? (56%)
How to replace the certain column with specified words? (55%)
How to rename different file name suffix to the same? (55%)
How to search and replace text for specified occurrences with reg exp? (54%)
How to replace a string that not enclosed by specific html tag? (54%)
How to replace all specified symbols with dot in specified range? (53%)
How to batch replace files with specified format in each line? (52%)

Check Demo of Advanced search and replace
Keywords:
specific word  based on  decimal  specific  else  dec  same  different  run following for each matched unit  tab  decimal number  replace same with different  replace different to same  specific line  replace with specific  replace same word  replace the same word  each line to replace different