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:
188
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 titles of all html files and save them to one file?
(66%)
How to extract all lines with specified date range from text file?
(63%)
How to extract titles from many html files into a txt file?
(63%)
How to extract all specified date format from a text file?
(62%)
How to extract tables from html files into csv file automatically?
(61%)
How to extract text from many webpage files and form a dabase file?
(61%)
How to extract multiple lines in specified order from many text files?
(60%)
Check Demo of
Text file parser
Keywords:
phone
field
123
create
extract multiple
csv
address
addr
data
file parser
extract csv
multiple file create
replace with multiple data
replace multiple csv
file create
csv from
open source text file parser
text file parser open source