| User: Jiang nan -- 2021-12-30 << 1461 1463 >> |
| Hits: 2198 |
| 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 |