User: editor -- 2011-07-30 << 827 829 >> |
Hits: 6358 |
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 sort csv files by two or more columns? (63%) 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%) |
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 |