| User: vlad -- 2014-02-11 << 1172 1174 >> |
| Hits: 1966 |
| 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 extract specified text from pdf files? (70%) 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%) |
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 |