User: vlad -- 2016-12-28 << 1385 1387 >> |
Hits: 3325 |
Type: Text file parser |
Search all Text file parser examples |
Description: |
How to extract column 1 and 7 from csv files and replace each dash with space? |
Input Sample: |
c1, c2, c3, c4, c5, c6, c7, c8 2006-005-028, d2, d3, d4, d5, d6, d7, d8 2006-007-011, d2, d3, d4, d5, d6, d7, d8 2006-007-012, d2, d3, d4, d5, d6, d7, d8 |
Output Sample: |
c1, c7 2006 005 028, d7 2006 007 011, d7 2006 007 012, d7 |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. open "Tools->Batch Runner" menu 2. drag and drop multple files from file browser to "batch runner" window.* set 'replace unit' to 'Line' 3. check option of "change output folder" to select an new output folder 4. click "fast replace" button * click "add" to add new replace rule * set "search" to blank * set "replace" to: * click "ok" * uncheck "cross line" option * click "start" |
Screenshot 1: Fast_Replace_Window |