Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1386.Text file parser -- How to extract column 1 and 7 from csv files and replace each dash with space?

User: vlad -- 2016-12-28          << 1385  1387 >>
Hits: 1198
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


Similar Examples:
How to extract 3,4,5th columns from csv file and replace comma with space? (77%)
How to extract column X from csv file where X is decided by column A? (64%)
How to extract the 7th column from text files with 8 columns? (56%)
How to delete last column in a csv file? (55%)
How to extract column 3,6,7,8 from each line of text? (55%)
How to remove commas and replace with a single space? (53%)
How to generate a csv file from a template file and a list of words? (53%)
How to extract text from many webpage files and form a dabase file? (53%)

Check Demo of Text file parser
Keywords:
dash  extract column  extract colum  csv files  blank  cross line  output folder  space  csv  rule  batch csv extract column  match dash line  add space batch  batch extract column  batch replace dash  batch extract column from file  blank space  replace dash