| User: Dilip -- 2014-09-05 << 1242 1244 >> |
| Hits: 2721 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| I have the Feed.csv file is tab delimited 115748-d 21061 rover Jaguar 115748-d 21062 sedan Benz 281770-d 21063 car Audi How to change column 1 and 4 to upper case |
| Input Sample: |
| 115748-d 21061 rover Jaguar 115748-d 21062 sedan Benz 281770-d 21063 car Audi |
| Output Sample: |
| 115748-D 21061 rover JAGUAR 115748-D 21062 sedan BENZ 281770-D 21063 car AUDI |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open text/csv file 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Word' * set 'replace scope' to 'Line' * set 'unit number filter' to: * set 'replace with pattern' to: 3. click 'replace', done. |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to change all the letters in a text file to upper cases? (68%) How to exchange column 2 and column 3 in multiple csv files? (64%) How to change all lines to columns in a text? (59%) How to change first letter of every word to uppercase in first line? (58%) How to merge more columns into one column in multiple csv files? (56%) How to change delimiter of the csv file from semicolon to comma with quota? (53%) How to batch change filename from upper case to lower case? (53%) How to read the text from a web page and change all letters to lower case? (52%) |
Check Demo of Advanced search and replace |
| Keywords: |
| tab delimited 210 delimited upper upper case change letter letters letter unit number filter number filter change upper change text to csv replace upper change text case search replace text in csv column scope filter replace letters column search and replace in csv |