User: Dilly -- 2019-07-15 << 1438 1440 >> |
Hits: 2059 |
Type: Text sort |
Search all Text sort examples |
Description: |
Sort by alphabetical descending order and numbers in ascending order in a csv file. Sort by column 4 (Alphabetical descending order) and then sort by column 2 (numerical ascending order) |
Input Sample: |
Condion,Num,Code,Brand TRUE,3,gtx,Audi TRUE,5,gty,Benz FALSE,7,hfx,Audi TRUE,10,flix,Benz TRUE,12,corn,Audi TRUE,11,text,Benz TRUE,10,nada,Volkswagen |
Output Sample: |
Condion,Num,Code,Brand TRUE,10,nada,Volkswagen TRUE,5,gty,Benz TRUE,10,flix,Benz TRUE,11,text,Benz TRUE,3,gtx,Audi FALSE,7,hfx,Audi TRUE,12,corn,Audi |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. ctrl-o open text file 2. ctrl-h open 'replace' dialog * set 'replace with pattern' to: 3. click 'settings' tab, set 'input delimiter' to comma: 4. click 'replace', done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Settings_Window |
Similar Examples: |
How to batch sort csv files by the order of value in the specified column? (65%) How to sort all the lines of a text file by order the multiple columns? (62%) How to split a csv file according to the value of column A? (60%) How to substract one csv file from another according to value of column A? (59%) How to sort lines of text file by comparing the sum of column1, 2 and 3? (58%) How to sort a text/csv file by the date DD/MM/YYYY in second column? (58%) How to sort the lines in a text files by the order of line length? (58%) How to sort each line of text by the order of reversed line? (57%) |
Check Demo of Text sort |
Keywords: |
descending sort csv files sort csv file sort csv desc mer csv files two delimiter columns order text lines in files sort csv file by column csv sort replace comma lines replace tab with comma in text file two columns match replace comma tab sort numbers in text file |