| User: Michelle Lyles -- 2015-12-01 << 1326 1328 >> |
| Hits: 2906 |
| 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 |