Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

874.Text merge -- How to merge content of column "A" if columns "B" and "C" are duplicate?

User: Rodrigo -- 2011-10-14          << 873  875 >>
Hits: 1637
Type: Text merge   
Search all Text merge examples
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
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

Screenshot 3:  Replace_Settings_Window

Similar Examples:
How to merge two columns of a CSV file? (54%)
How to copy column A to column D if column D is blank(absent) in a csv file? (52%)
How to delete line with specific columns in specific range? (51%)
How to extract specified columns from a large pipe separated csv file? (51%)
How to replace the 4th column if the 5th column is 0? (50%)
How to merge the data of second column base on value of first column? (50%)
How to extract the 7th column from text files with 8 columns? (49%)
How to merge different CSV with partially different columns into one? (48%)

Check Demo of Text merge
transform  chm  seperate  trans  tea  unique  text merge  merge  merg  mer  duplicate merge  unique values  merge csv columns  duplicate lines csv  merge unique lines  csv merge  merge csv  duplicate csv