Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

719.Text file parser -- How to extract the second column from a database text file?

User: editor -- 2011-02-17          << 718  720 >>
Hits: 2727
Type: Text file parser   
Search all Text file parser examples
Description:
How to extract the second column from a database text file? 
There is a database txt file with many records, each record has many elements or columns that seperated by a "|", how to extract the second element in each record, and join them with comma ","?
Input Sample:
a1|a2|a3|a4|a5 
b1|b2|b3|b4|b5 
c1|c2|c3|c4|c5 
....
Output Sample:
a2,b2,c2,d2,...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open database file(txt). 
2. ctrl-h open replace window 
* set 'replace unit' to 'Line' 
* set 'replace with pattern' to: 
 
3. click 'replace', done! 
4. ctrl-s save to disk.

Screenshot 1:  Replace_Window


Similar Examples:
How to replace the second column in a tab seperated file? (78%)
How to delete the second column in multiple text files? (75%)
How to extract all odd columns 1,3,5,... from a text file? (70%)
How to extract specified columns from blocks of text? (68%)
How to extract specified text followed by 8 digits from text file? (67%)
How to extract all telephone numbers from a text file? (67%)
How to batch extract specified lines from a text file? (67%)
How to extract all specified date format from a text file? (66%)

Check Demo of Text file parser
Keywords:
database  records  seperate  record  second column  columns  second  comma  data  join  join records  how to extract column to text file in database  extract by column  replace second comma in text file  text to database  how to extract columns from a text file  extract columns  join columns