| User: editor -- 2011-01-06 << 691 693 >> |
| Hits: 4296 |
| Type: Text sort |
| Search all Text sort examples |
| Description: |
| How to sort a text/csv file by the date DD/MM/YYYY in second column? |
| Input Sample: |
| 3,17/2/2008,AAA 5,8/12/2005,BBB 1,3/1/1999,CCC 8,12/5/2001,DDD 6,18/11/2005,EEE |
| Output Sample: |
| 1,3/1/1999,CCC 8,12/5/2001,DDD 6,18/11/2005,EEE 5,8/12/2005,BBB 3,17/2/2008,AAA |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source txt/csv file 2. ctrl-h open 'replace' window * set 'replace with pattern' to: 3. click 'settings' tab, set 'input delimiter' and 'output delimiter' to 'other', and enter a single comma behind.(note: if text is seperated by space, just set input/output delimiter to 'space') 4. click 'replace', done! 5. if there are multiple files, click 'batch...' and drag multiple files to 'batch runner' window, and click 'batch replace' button. Note: Replace Pioneer 2.6 and newer version is required for the 'date' parameter of function sort_by_word() Please check following for definition of functions: http://www.mind-pioneer.com/replace/help/Functions.html |
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? (64%) How to sort the text file by the date at the beginning of each line? (60%) How to sort csv files by two or more columns? (58%) How to sort all the lines of a text file by order the multiple columns? (58%) How to sort a text file by the length of text in each line? (57%) How to split a csv file according to the value of column A? (56%) How to sort lines of text file by comparing the sum of column1, 2 and 3? (56%) How to split a text file with specified start and end line and name? (54%) |
Check Demo of Text sort |
| Keywords: |
| definition parameter seperate yyyy functions second column help delimiter function second input parameter replace tab space with comma batch file replace space with tab batch file replace space by comma text file batch replace space by comma batch replace input source batch file text file replace space tab batch file space to tab |