Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

692.Text sort -- How to sort a text/csv file by the date DD/MM/YYYY in second column?

User: editor -- 2011-01-06          << 691  693 >>
Hits: 2805
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 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 sort the text by the number of specific word in each line? (54%)
How to parse data from the text file and create text with  user specified format? (53%)

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