| User: editor -- 2011-07-30 << 827 829 >> |
| Hits: 330 |
| 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 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 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 sort each line of text by the order of reversed line? (58%) How to batch rename files with the first word of file contents? (58%) How to sort all the lines of a text file by order the multiple columns? (57%) How to sort the lines in a text files by the order of line length? (57%) |
Check Demo of Text sort |
| Keywords: |
| batch sort csv batch sort csv file sort csv delimiter batch sort order csv text sort settings setting batch file input value sort in csv file from batch sort csv file batch sort csv batch batch file sort csv files batch to sort csv file batch csv sort sort batch csv files |