How to separate files by the ninth digit
My idea would be to keep only the ones that contain the number "8" in the ninth position.
Example: A list of numbers with 11 numbers each line
162156258 12 we keep this one because it's an "8" in the ninth position
612644264 75 this one would be deleted
621285076 89 this one would be deleted
872275028 72 this would be kept...
78686825079
12801683230
87545141857
46821584818
51704231523
15256375253
60512053812
85746520080
80014785137
46648611847
Is it possible to do that in notepad? Is there any site I can do that? How could i do that? Thank you all
Solution
Using Notepad++
- Ctrl+H
- Find what:
^\d{8}[^8].*\R? - Replace with:
LEAVE EMPTY - CHECK Wrap around
- CHECK Regular expression
- UNCHECK
. matches newline - Replace all
Explanation:
^ # beginning of line
\d{8} # 8 digits
[^8] # a character that is not "8"
.* # 0 or more any character
\R? # any kind of linebreak, optional
Screenshot (before):
Screenshot (after):
- Does xslt have split() function?
- How do I split a string in zig by a specific character?
- Excel VBA search for data and stuck at a certain point due to group or split source file?
- Splitting a dataset into equal parts [All possible halves]
- String cleaning removing consecutive value and put comma in the end
- Splitting a string that is delimited by multiple delimiters (regex)
- PHP:: Selectively pack zip-archives from files in folder
- How to get string positions And Length by multi-split filter
- Extract first digit sequence from string containing digits, non-digits and then digits
- how can I retrieve Photoshop artlayer names from specific sub-layerset into an array?
- Split a string in Painless/ELK
- How to separate the string by specific symbols and write it to list?
- How can I split an array into n parts?
- Multiple word search feature HTML list filter
- Unable to extract timestamp from Date/Timestamp combo column in Excel 2016
- Perl assignment with a dummy placeholder
- PHP break array each time the a specified value appears into separate arrays
- Split one table to multiple tables
- How can I maximize a split window?
- Split string and convert the substrings to integers in Go
- Split string with limit, where last string contains the remainder
- Split array into chunks
- How to Split a String Up into Individual Characters
- How to prevent the SPLIT function from converting text to non-text in Google Sheets
- How do I split a string with multiple separators in JavaScript?
- How to split file by percentage of no. of lines?
- Split String in Swift by their capital letters
- Python regular expression for multiple split criteria
- Passing Dynamic parameter using STRING_SPLIT to IN parameter
- How do I split my bed bim and fam files by family ID in plink?