Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

960.Advanced search and replace -- How to join every 3 lines into 3 columns of csv file?

User: editor -- 2012-06-16          << 959  961 >>
Hits: 1631
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to convert 3 consecutive lines into 3 columns of csv file?
Input Sample:
f1
f2
f3
f4
f5
f6
f7
f8
f9
...
Output Sample:
f1,f2,f3
f4,f5,f6
f7,f8,f9
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source text file
2. ctrl-h open 'replace' dialog
* set 'replace unit' to 'Line'
* set unit number filter to:

* set 'replace with pattern' to:

3. click 'replace', done.

Note: 3<3> means 3, 6, 9, 12, ... !3<3> means 1,2, 4,5, 7,8, 10,11, ...

Screenshot 1:  Replace_Window


Similar Examples:
How to join every n lines into 1 line in a text file? (79%)
Join every 3 lines into one line (69%)
How to delete last column in a csv file? (67%)
How to join same language lines into 1 line in a text file? (66%)
How to join every 50 or 500 lines together in a text file? (63%)
How to convert a vcf file with multiple entries into a csv file? (61%)
How to remove all lines with duplicate value in column B in CSV file? (61%)
How to add some number to the specific column in csv file? (61%)

Check Demo of Advanced search and replace
Keywords:
101  join every 3 lines  consecutive  onsecutive  cut  unit number filter  columns  number filter  how to convert  csv  convert csv  join columns of text  join csv  join columns  convert number  convert text to number  convert to number  csv text to columns