Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1327.Advanced search and replace -- How to set column N according to some words in column A in csv file?

User: Michelle Lyles -- 2015-12-01          << 1326  1328 >>
Hits: 1228
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
Hello:
May I request a solution very similar to #1325?
In particular, I am working with a csv database. I would like to find
specific words in a string of text. Copy this word, and move it to another
cell. I do not want the word deleted from its original position.
Example:
Column A (PRODUCT NAMES)
Column N (SIZE) is empty
I would like to find the specified words (small, medium and large) in Column
A and copy the words to Column N.
Thank you!
Input Sample:
Column A (PRODUCT NAME) 
Row 1:  This is a Medium product 
Row 2:  This is a Small product 
Row 3:  This is a Medium product 
Row 4:  This is a Large product 
Row 5:  This is a Small product 

Column N (SIZE) 
Row 1:   
Row 2:   
Row 3:   
Row 4:   
Row 5:
Output Sample:
Column A (PRODUCT NAME) 
Row 1:  This is a Medium product 
Row 2:  This is a Small product 
Row 3:  This is a Medium product 
Row 4:  This is a Large product 
Row 5:  This is a Small product 

Column N (SIZE) 
Row 1:  Medium 
Row 2:  Small 
Row 3:  Medium 
Row 4:  Large 
Row 5:  Small
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
Make sure the csv file columns are seperated by comma.
1. ctrl-o open csv file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:

* set 'if=>' to:

3. click 'replace', done.
4. ctrl-s save to file.

Note:
For multiple files, you can click 'Batch...' button in step 3, and drag multiple files from file browser to 'Batch runner' window, and click 'batch replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to set column N according to content of column A in csv file? (88%)
How to duplicate column A by the number of times in column B in csv file? (64%)
How to search and replace words in specified column in csv file? (63%)
How to merge more columns into one column in multiple csv files? (62%)
How to count the occurrance of some specified words in many files? (62%)
How to reverse all the words in each line of a csv file? (61%)
How to delete last column in a csv file? (59%)
How to count the occurrence of a list of words in a text file? (59%)

Check Demo of Advanced search and replace
Keywords:
empty  specific words  database  cell  size  specific word  position  similar  seperate  scalar  batch split columns word  batch split comma  batch string replace split  batch file split string  batch split csv file columns  batch file split comma  split columns from text files  find and replace multiple words