Replace Pioneer Home
All Examples
Free Download
all
Advanced search and replace
Replace text in multiple files
Regular expression replace
Batch file rename
Batch download
Text file parser
Text file splitter
Html text generator
Search replace binary
Random word generator
Count and statistics
Character encoding
Bin Hex Oct Dec converter
Text generator
Text sort
Text merge
Text data calculation
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:
4649
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:
[\s\*]+ name:([^\n]+) age:([^\n]+) address:([^\n]+) phone:([^\n]+)
* set 'replace with pattern' to:
$1,$2,$3,$4\n
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