Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1243.Advanced search and replace -- How to change letters in Column1 and Column4 to upper case?

User: Dilip -- 2014-09-05          << 1242  1244 >>
Hits: 1337
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