| User: Dilip -- 2017-10-09 << 1403 1405 >> |
| Hits: 3252 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| Delete rows in csv based on criteria of the following found in Column 7 and Column 8: All Merchants must have at least one Stock count. Else, then delete all items from Merchant |
| Input Sample: |
| 1,2,3,4,5,6,Marchant1,Stock 1,2,3,4,5,6,Merhcant2,NoStock 1,2,3,4,5,6,Marchant1,NoStock 1,2,3,4,5,6,Merhcant2,NoStock |
| Output Sample: |
| 1,2,3,4,5,6,Marchant1,Stock 1,2,3,4,5,6,Marchant1,NoStock |
| 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' dialogue * set 'replace unit' to 'Line' * set 'if' to: * click 'advanced' tab, set 'run following at the beginning of replace' to: 3. click replace, done. 4. ctrl-s save to file. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |