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: 891
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