Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1173.Text file parser -- How to extract specified text followed by 8 digits from text file?

User: vlad -- 2014-02-11          << 1172  1174 >>
Hits: 1215
Type: Text file parser   
Search all Text file parser examples
Description:
How to extract specified text followed by 8 digits from text file?
I need to generate list of all text that has "DRE" in it. Basically text is the following: DRE: 84902839 some random numbers. I just need DRE: space and 8 digits collected in the column format how do I do it?
Input Sample:
Basically text is the following: DRE: 84902839 some random numbers
DRE: 13246589 
Output Sample:
DRE: 84902839
DRE: 13246589
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open text file(you need save xls file to csv or txt if your file is not text file)
2. ctrl-h open 'replace' dialogue
* set 'search for pattern' to:

* set 'replace with pattern' to:

* uncheck 'print unmatched unit' option
3. click 'replace', done.
4. ctrl-s save to file.

Screenshot 1:  Replace_Window


Similar Examples:
How to extract all specified date format from a text file? (74%)
How to exract specified strings started with www from text file? (70%)
How to batch extract specified lines from a text file? (69%)
How to extract specified lines in different section of text file? (68%)
How to extract all lines with specified date range from text file? (67%)
How to extract the second column from a database text file? (67%)
How to extract specified columns from blocks of text? (66%)
How to extract all specified links from a html file? (66%)

Check Demo of Text file parser
Keywords:
xls  asic  digits  random number  digit  dig  generate list  random  rando  rand  replace digits with random digits  generate all numbers txt  xls to csv  format csv txt  how to extract random  extract by column  replace text with list random  extract text and numbers