Replace Pioneer Home
All Examples
Free Download
all
Advanced search and replace
Replace text in multiple files
Regular expression replace
Batch file rename
Batch download
Text file parser
Text file splitter
Html text generator
Search replace binary
Random word generator
Count and statistics
Character encoding
Bin Hex Oct Dec converter
Text generator
Text sort
Text merge
Text data calculation
RSS: Replace Pioneer Examples
1007.Text sort -- How to reverse the order of the first column in text file?
User:
LYNNE -- 2012-09-21
<< 1006
1008 >>
Hits:
3859
Type:
Text sort
Search all
Text sort
examples
Description:
How to reverse the date of all the lines in a text file?
Input Sample:
2008/10/06 1.4741
2008/10/07 1.3866
2008/10/08 1.3888
2008/10/09 1.2862
2008/10/10 1.2903
2008/10/13 1.2169
Output Sample:
2008/10/13 1.4741
2008/10/10 1.3866
2008/10/09 1.3888
2008/10/08 1.2862
2008/10/07 1.2903
2008/10/06 1.2169
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' dialogue
* set 'replace with pattern' to:
transpose(words_r(lines(transpose($match),1),1,-1)."\n".lines(transpose($match),2,-1),'\s+',' ')
3. click 'replace', done.
Screenshot 1: Replace_Window
Similar Examples:
How to reverse the order of all the lines in a text file?
(81%)
How to remove/delete first column for multiple files?
(70%)
How to reverse the order of characters in each line of text?
(70%)
How to reverse all the space-separated columns in many text file?
(67%)
How to replace a word with a list of words repeatly in a text file?
(66%)
How to remove everything after the first comma in each line in a text file?
(65%)
How to delete the second column in multiple text files?
(64%)
How to insert a keyword only at first line of multiple text files?
(63%)
Check Demo of
Text sort
Keywords:
reverse the order
transpose
trans
reverse
first column
order
text sort
date
sort
ran
reverse lines
sort first
order lines text file
sort all lines
replace in reverse text
reverse text
sort lines of text
sort text lines