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: 1580
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


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
Keywords:
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