|User: editor -- 2011-02-17 << 718 720 >>|
|Type: Text file parser|
|Search all Text file parser examples|
|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 ","?
|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
|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
|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|