Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

897.Text file parser -- How to extract multiple fields from data file and create a csv file?

User: editor -- 2011-12-19          << 896  898 >>
Hits: 2059
Type: Text file parser   
Search all Text file parser examples
Description:
How to extract multiple fields from data file and create a csv file?
Input Sample:
***************
name:Jack
age:28
address:street one
phone:12345678
***************
name:Tommy
age:33
address:street two
phone:87654321
***************
...
Output Sample:
Jack,28,street one,12345678
Tommy,33,street two,87654321
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source text file
2. ctrl-h open 'replace' dialogue
* set 'search for pattern' to:

* set 'replace with pattern' to:

3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to extract first line from multiple files and generate a new file? (68%)
How to extract tables from many html files into one csv file? (67%)
How to search/replace multiple text files base on rules from csv file? (67%)
How to extract titles of all html files and save them to one file? (66%)
How to batch extract html title from files and link to the file? (63%)
How to make multiple copies of a file and rename them from a list? (63%)
How to extract specified columns from a large pipe separated csv file? (63%)
How to extract all lines with specified date range from text file? (63%)

Check Demo of Text file parser
Keywords:
1234  phone  field  123  create  extract multiple  csv  address  addr  data  extract fields  create csv  create csv file  extract data from text file  extract data  create text multiple  extract csv  multiple file create