| User: Fiona -- 2013-06-23 << 1089 1091 >> |
| Hits: 4201 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| A CSV file has 3 columns, a, b and c. How to merge two columns into one in this CSV file, the main separator between columns is ";" with piping as separator between the columns b and c |
| Input Sample: |
| column a;column b;column c |
| Output Sample: |
| column a;column b|c |
| 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 'Chars' * set 'replace scope' to 'Line' * set 'unit number filter' to: * set 'search for pattern' to * set 'replace with pattern' to 3. click 'replace', done. For multiple files, click "batch..." button in step 3, and drag multiple csv files to "batch runner" window, and click "batch replace", done. |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to delete last column in a csv file? (70%) How to merge other columns one by one into the first column? (62%) How to join every 3 lines into 3 columns of csv file? (62%) How to merge remaining columns into the first column? (61%) How to merge the data of second column base on value of first column? (60%) How to merge many files into one file? (59%) How to reverse the order of the first column in text file? (59%) How to merge more columns into one column in multiple csv files? (59%) |
Check Demo of Advanced search and replace |
| Keywords: |
| how to merge two columns merge two column merge two merge merg mer csv files two unit number filter columns batch csv filter merge file merge csv files into one with multiple columns merge multiple columns in csv file csv merge columns batch merge two columns files batch merge two csv files batch file to merge columns merge csv files columns |