| User: Michelle Lyles -- 2015-11-21 << 1325 1327 >> |
| Hits: 2841 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| I have two csv files (each file contains about 6000 rows and 20 columns). One file is a database of products from the August Catalog. The other file is a database of products from the November Catalog. Column A of both files contains product sku numbers. I would like to subtract the August Catalog from the November Catalog. The resulting csv file will contain only new products. |
| Input Sample: |
| August, Catalog: SKU, NAME, DESCRIPTION 123, name1, html-1 456, name2, html-2 Aa456, name3, html-3 Aa789, name4, html-4 aa-123, name5, html-5 aa-456, name6, html-6 November, Catalog: SKU, NAME, DESCRIPTION 789, new1, html-a 123, name1, html-1 456, name2, html-2 Aa456, name3, html-3 new123, new2, html-b Aa789, name4, html-4 aa-123, name5, html-5 aa-456, name6, html-6 new-001, name, html-c |
| Output Sample: |
| New Product Catalog: SKU NAME DESCRIPTION 789 new1 html-a new123 new2 html-b new-001 name html-c |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| Assume two files are, they are comma separated. d:\test\Nov.csv d:\test\Aug.csv 1. ctrl-o open Nov.csv 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. Note: in step 2 file folder separater should be double backslash like d:\\test\\Aug.csv. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |