| User: Rodrigo -- 2011-10-14 << 873 875 >> |
| Hits: 3796 |
| Type: Text merge |
| Search all Text merge examples |
| Description: |
| How to merge content of column "A" in CSV file, if content of columns "B" and "C" are duplicate values in lines, and transform it in unique line? |
| Input Sample: |
| 12345;Content Example 01;ABCDE 11223;Content Example 01;ABCDE 90907;Content Example 02;HIJK 3434;Content Example 02;HIJK 888;Example Text;hello 000;Example Text;hello 111;Example Text;hello |
| Output Sample: |
| 12345,11223;Content Example 01;ABCDE 90907,3434;Content Example 02;HIJK 888,000,111;Example Text;hello |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open the CSV file 2. ctrl-h open 'replace' window * set 'replace unit' to 'Line' * set 'replace with pattern' to: * click 'advanced' tab * set 'run following for each matched unit' to: * click 'settings' tab, set "word delimiter->input delimiter" to 'others', and set the following entry to: 3. click 'replace', done. Note: if the file is comma seperated csv file, you should change "word input delimter" to "," instead of ";" in step2. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |