Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

828.Text sort -- How to batch sort csv files by the order of value in the specified column?

User: editor -- 2011-07-30          << 827  829 >>
Hits: 3339
Type: Text sort   
Search all Text sort examples
Description:
How to batch sort csv files by the order of value in the specified column?
For example, sort csv files by the column 3?
Input Sample:
a1, b1, 5, d1, e1
a2, b2, 7, d2, e2
a3, b3, 9, d3, e3
a4, b4, 2, d4, e4
Output Sample:
a4, b4, 2, d4, e4
a1, b1, 5, d1, e1
a2, b2, 7, d2, e2
a3, b3, 9, d3, e3
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-h open 'replace' dialog
* set 'replace with pattern' to:

* click 'settings' page, set 'input delimiter' to 'other', and set the following entry to: 
2. click 'Batch...' button open 'Batch Runner' window
3. drag multiple csv files from "windows file manater" to 'Batch Runner' window, and click 'Batch Replace', done!

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Settings_Window


Similar Examples:
How to delete rows in csv based on criteria of specified column? (65%)
How to substract one csv file from another according to value of column A? (65%)
How to split a csv file according to the value of column A? (65%)
How to sort a text/csv file by the date DD/MM/YYYY in second column? (64%)
How to batch rename csv file with text from 2nd line, 2nd column of file? (61%)
How to split a CSV file with Header according to value of a column? (61%)
How to batch rename text files by adding the value of file content to filename? (61%)
How to batch rename files by remove everything after specificed string? (60%)

Check Demo of Text sort
Keywords:
batch sort csv  batch sort csv file  sort csv files  sort csv  sort csv file  csv files  batch sort  delimiter  order  text sort  windows sort csv delimiter  delimiter csv batch windows  batch file input value  sort in csv file from batch  sort csv file from batch  input from csv  batch sort by column csv  sort by column csv batch