Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1325.Advanced search and replace -- How to set column N according to content of column A in csv file?

User: Michelle Lyles -- 2015-11-18          << 1324  1326 >>
Hits: 1259
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
I am working with a csv database. I would like to find a specific word a string of text. Copy this word, and move it to another cell. I do not want the word deleted from the product name.
Example:
Column A contains PRODUCT NAMES
Column N is empty
I would like to find the word red in Column A and copy the word red to Column N.
Result the word red appears in both Column A and Column N
Input Sample:
Column A (PRODUCT NAME)
Row 1:  This is a red product
Row 2:  This is a blue product
Row 3:  This is a red product
Row 4:  This is a green product
Row 5:  This is a red product

Column N (COLOR)
Row 1:  
Row 2:  
Row 3:  
Row 4:  
Row 5:  
Output Sample:
Column A (PRODUCT NAME)
Row 1:  This is a red product
Row 2:  This is a blue product
Row 3:  This is a red product
Row 4:  This is a green product
Row 5:  This is a red product

Column N (COLOR)
Row 1:  red
Row 2:  
Row 3:  red
Row 4:  
Row 5:  red
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 some words in column A in csv file? (88%)
How to extract from a file according to content of another file? (66%)
How to duplicate column A by the number of times in column B in csv file? (66%)
How to merge more columns into one column in multiple csv files? (65%)
How to delete last column in a csv file? (64%)
How to split a csv file according to the value of column A? (61%)
How to exchange column 2 and column 3 in multiple csv files? (60%)
How to split a file into two parts according to the content of line? (59%)

Check Demo of Advanced search and replace
Keywords:
empty  database  cell  specific word  seperate  scalar  specific  acc  contains  find  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