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: 2115
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 first number in each line for multiple files? (63%)
How to remove the first 10 characters of each line in text file? (63%)

Check Demo of Advanced search and replace
Keywords:
syntax  functions  tax  reverse  refer  help  delimiter  function  mind  csv  reverse words  reverse line  search replace csv  csv search replace  replace line in csv  csv line file  search words  words to replace