| User: editor -- 2010-09-14 << 611 613 >> |
| Hits: 3847 |
| 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 rearrange the words in each line and top of file? (76%)
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%)
|
|
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 |