Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

612.Advanced search and replace -- How to reverse all the words in each line of a csv file?

User: editor -- 2010-09-14          << 611  613 >>
Hits: 460
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to reverse all the words in each line of a csv file?
Input Sample:
a1,a2,a3,a4
b1,b2,b3,b4
c1,c2,c3,c4
...
Output Sample:
a4,a3,a2,a1
b4,b3,b2,b1
c4,c3,c2,c1
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source csv file
2. ctrl-h open 'replace' window
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:

3. click 'Replace', done!
4. ctrl-s save to file

Notes: syntax of words_r:
words_r(text,start_no[,end_no,[input_delimiter,[output_delimiter,[column_width1,column_width2,...]]]])

refer to: http://www.mind-pioneer.com/replace/help/Functions.html 

Screenshot 1:  Replace_Window


Similar Examples:
How to delete the first word in each line in a text file? (71%)
How to remove all letters before "=" in each line of text file? (68%)
How to reverse the order of characters in each line of text? (67%)
How to reverse the order of all the lines in a text file? (67%)
How to reverse all cases of letters in a text file? (67%)
How to sort all words in alphabetic order for each line in CSV file? (65%)
How to remove the first 10 characters of each line in text file? (63%)
How to remove leading and trailing blanks in each line in many files? (62%)

Check Demo of Advanced search and replace
Keywords:
syntax  reverse  functions  refer  help  delimiter  csv  function  input  www  reverse words  reverse line  search words  words to replace  replace words  words replace  search and replace open source  search line