| User: Michelle Lyles -- 2015-11-18 << 1324 1326 >> |
| Hits: 2760 |
| 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 |