Deleting everything after matched line
up vote
1
down vote
favorite
I have a standard txt file. I want to delete everything after a certain point.
I have captured everything I want to keep using the following regex:
(.+td+t.+tdt.+td.+)
In the txt file, there will be a line that has Row Count t (followed by row count number)
Example: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t123tEntertainmenttA12342A1234567890A
Row Countt123456
Abcdefghij AbcdtAbcdefghij AbcdtAbcdefghtAbc Abcdefg Abcde
ABtFamily Monthly Gratis Trialt1234t0.00
ABtIndividual Monthly Gratis Trialt12345t0.00
ABtStudent Monthly Gratis Trialt1234t0.00
ABtFamily Introductory OFFERt123456t123.45
ABtIndividual Introductory OFFERt123456t1234.56
ABtStudent Individual Introductory OFFERt12345t123.45
ABtFamily Monthly PAIDt1234567t12345.67
ABtIndividual Annual PAIDt12345t123.45
ABtIndividual Monthly PAIDt1234567t12345.67
ABtStudent Individual Monthly PAIDt123456t1234.56
Desired Result: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t300tEntertainmenttA12342A1234567890A
I want to delete the 'Row Count' row as well as everything that follows afterwards.
Any help on this would be greatly appreciated
regex notepad++
asked Nov 22 at 11:15
James Upson
84
|
show 1 more comment
up vote
1
down vote
favorite
I have a standard txt file. I want to delete everything after a certain point.
I have captured everything I want to keep using the following regex:
(.+td+t.+tdt.+td.+)
In the txt file, there will be a line that has Row Count t (followed by row count number)
Example: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t123tEntertainmenttA12342A1234567890A
Row Countt123456
Abcdefghij AbcdtAbcdefghij AbcdtAbcdefghtAbc Abcdefg Abcde
ABtFamily Monthly Gratis Trialt1234t0.00
ABtIndividual Monthly Gratis Trialt12345t0.00
ABtStudent Monthly Gratis Trialt1234t0.00
ABtFamily Introductory OFFERt123456t123.45
ABtIndividual Introductory OFFERt123456t1234.56
ABtStudent Individual Introductory OFFERt12345t123.45
ABtFamily Monthly PAIDt1234567t12345.67
ABtIndividual Annual PAIDt12345t123.45
ABtIndividual Monthly PAIDt1234567t12345.67
ABtStudent Individual Monthly PAIDt123456t1234.56
Desired Result: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t300tEntertainmenttA12342A1234567890A
I want to delete the 'Row Count' row as well as everything that follows afterwards.
Any help on this would be greatly appreciated
regex notepad++
asked Nov 22 at 11:15
James Upson
84
Please, edit your question and add sample text and expected result.
– Toto
Nov 22 at 11:42
(.+td+t.+tdt.+td.+)does not matchRow Count 278017. What did you mean to say? Also, see Remove everything except a certain pattern. If the files are short, this solution might do what you need.
– Wiktor Stribiżew
Nov 22 at 11:42
Do you want to delete all until the end of the file? Or other limit? And what about everything that is present before? Are there linebreak somewhere or is it a single line?
– Toto
Nov 22 at 12:32
Is "Find what:Row Count.+", "Replace with:LEAVE EMPTY" working for you? Don't forget to check. matches newline
– Toto
Nov 22 at 12:37
Try(?s)^Row Count.*. Are thosetTABs or just two char sequences? BTW, if they are tabs you may use your pattern like(.+td+t.+tdt.+td.+)R(?s).*and replace with$1.
– Wiktor Stribiżew
Nov 22 at 12:38
|
show 1 more comment
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have a standard txt file. I want to delete everything after a certain point.
I have captured everything I want to keep using the following regex:
(.+td+t.+tdt.+td.+)
In the txt file, there will be a line that has Row Count t (followed by row count number)
Example: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t123tEntertainmenttA12342A1234567890A
Row Countt123456
Abcdefghij AbcdtAbcdefghij AbcdtAbcdefghtAbc Abcdefg Abcde
ABtFamily Monthly Gratis Trialt1234t0.00
ABtIndividual Monthly Gratis Trialt12345t0.00
ABtStudent Monthly Gratis Trialt1234t0.00
ABtFamily Introductory OFFERt123456t123.45
ABtIndividual Introductory OFFERt123456t1234.56
ABtStudent Individual Introductory OFFERt12345t123.45
ABtFamily Monthly PAIDt1234567t12345.67
ABtIndividual Annual PAIDt12345t123.45
ABtIndividual Monthly PAIDt1234567t12345.67
ABtStudent Individual Monthly PAIDt123456t1234.56
Desired Result: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t300tEntertainmenttA12342A1234567890A
I want to delete the 'Row Count' row as well as everything that follows afterwards.
Any help on this would be greatly appreciated
regex notepad++
asked Nov 22 at 11:15
James Upson
84
I have a standard txt file. I want to delete everything after a certain point.
I have captured everything I want to keep using the following regex:
(.+td+t.+tdt.+td.+)
In the txt file, there will be a line that has Row Count t (followed by row count number)
Example: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t123tEntertainmenttA12342A1234567890A
Row Countt123456
Abcdefghij AbcdtAbcdefghij AbcdtAbcdefghtAbc Abcdefg Abcde
ABtFamily Monthly Gratis Trialt1234t0.00
ABtIndividual Monthly Gratis Trialt12345t0.00
ABtStudent Monthly Gratis Trialt1234t0.00
ABtFamily Introductory OFFERt123456t123.45
ABtIndividual Introductory OFFERt123456t1234.56
ABtStudent Individual Introductory OFFERt12345t123.45
ABtFamily Monthly PAIDt1234567t12345.67
ABtIndividual Annual PAIDt12345t123.45
ABtIndividual Monthly PAIDt1234567t12345.67
ABtStudent Individual Monthly PAIDt123456t1234.56
Desired Result: ABt1234567890tStudent Individual Monthly PAIDt1t.012345t.012345tABCD12345678tFuck RussttT-Waynet1t1tABCD12345678t0t300tEntertainmenttA12342A1234567890A
I want to delete the 'Row Count' row as well as everything that follows afterwards.
Any help on this would be greatly appreciated
regex notepad++
regex notepad++
asked Nov 22 at 11:15
James Upson
84
asked Nov 22 at 11:15
James Upson
84
edited Nov 22 at 16:12
asked Nov 22 at 11:15
James Upson
84
asked Nov 22 at 11:15
James Upson
84
asked Nov 22 at 11:15
James Upson
84
84
Please, edit your question and add sample text and expected result.
– Toto
Nov 22 at 11:42
(.+td+t.+tdt.+td.+)does not matchRow Count 278017. What did you mean to say? Also, see Remove everything except a certain pattern. If the files are short, this solution might do what you need.
– Wiktor Stribiżew
Nov 22 at 11:42
Do you want to delete all until the end of the file? Or other limit? And what about everything that is present before? Are there linebreak somewhere or is it a single line?
– Toto
Nov 22 at 12:32
Is "Find what:Row Count.+", "Replace with:LEAVE EMPTY" working for you? Don't forget to check. matches newline
– Toto
Nov 22 at 12:37
Try(?s)^Row Count.*. Are thosetTABs or just two char sequences? BTW, if they are tabs you may use your pattern like(.+td+t.+tdt.+td.+)R(?s).*and replace with$1.
– Wiktor Stribiżew
Nov 22 at 12:38
|
show 1 more comment
Please, edit your question and add sample text and expected result.
– Toto
Nov 22 at 11:42
(.+td+t.+tdt.+td.+)does not matchRow Count 278017. What did you mean to say? Also, see Remove everything except a certain pattern. If the files are short, this solution might do what you need.
– Wiktor Stribiżew
Nov 22 at 11:42
Do you want to delete all until the end of the file? Or other limit? And what about everything that is present before? Are there linebreak somewhere or is it a single line?
– Toto
Nov 22 at 12:32
Is "Find what:Row Count.+", "Replace with:LEAVE EMPTY" working for you? Don't forget to check. matches newline
– Toto
Nov 22 at 12:37
Try(?s)^Row Count.*. Are thosetTABs or just two char sequences? BTW, if they are tabs you may use your pattern like(.+td+t.+tdt.+td.+)R(?s).*and replace with$1.
– Wiktor Stribiżew
Nov 22 at 12:38
Please, edit your question and add sample text and expected result.
– Toto
Nov 22 at 11:42
Please, edit your question and add sample text and expected result.
– Toto
Nov 22 at 11:42
(.+td+t.+tdt.+td.+) does not match Row Count 278017. What did you mean to say? Also, see Remove everything except a certain pattern. If the files are short, this solution might do what you need.– Wiktor Stribiżew
Nov 22 at 11:42
(.+td+t.+tdt.+td.+) does not match Row Count 278017. What did you mean to say? Also, see Remove everything except a certain pattern. If the files are short, this solution might do what you need.– Wiktor Stribiżew
Nov 22 at 11:42
Do you want to delete all until the end of the file? Or other limit? And what about everything that is present before? Are there linebreak somewhere or is it a single line?
– Toto
Nov 22 at 12:32
Do you want to delete all until the end of the file? Or other limit? And what about everything that is present before? Are there linebreak somewhere or is it a single line?
– Toto
Nov 22 at 12:32
Is "Find what:
Row Count.+", "Replace with: LEAVE EMPTY" working for you? Don't forget to check . matches newline– Toto
Nov 22 at 12:37
Is "Find what:
Row Count.+", "Replace with: LEAVE EMPTY" working for you? Don't forget to check . matches newline– Toto
Nov 22 at 12:37
Try
(?s)^Row Count.*. Are those t TABs or just two char sequences? BTW, if they are tabs you may use your pattern like (.+td+t.+tdt.+td.+)R(?s).* and replace with $1.– Wiktor Stribiżew
Nov 22 at 12:38
Try
(?s)^Row Count.*. Are those t TABs or just two char sequences? BTW, if they are tabs you may use your pattern like (.+td+t.+tdt.+td.+)R(?s).* and replace with $1.– Wiktor Stribiżew
Nov 22 at 12:38
|
show 1 more comment
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
Assuming (.+td+t.+tdt.+td.+) matches the point after which you want to remove everything in the file to its end, you may append (?s).* to your pattern and replace with $1, a placeholder containing the text captured in the first group.
Do not enable . matches newline option. (?s) will make the next . match any chars including line break chars, it is an inline DOTALL modifier variant while the previous ones will still match all chars but line break chars.
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
1
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
Assuming (.+td+t.+tdt.+td.+) matches the point after which you want to remove everything in the file to its end, you may append (?s).* to your pattern and replace with $1, a placeholder containing the text captured in the first group.
Do not enable . matches newline option. (?s) will make the next . match any chars including line break chars, it is an inline DOTALL modifier variant while the previous ones will still match all chars but line break chars.
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
1
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
add a comment |
up vote
1
down vote
accepted
Assuming (.+td+t.+tdt.+td.+) matches the point after which you want to remove everything in the file to its end, you may append (?s).* to your pattern and replace with $1, a placeholder containing the text captured in the first group.
Do not enable . matches newline option. (?s) will make the next . match any chars including line break chars, it is an inline DOTALL modifier variant while the previous ones will still match all chars but line break chars.
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
1
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
Assuming (.+td+t.+tdt.+td.+) matches the point after which you want to remove everything in the file to its end, you may append (?s).* to your pattern and replace with $1, a placeholder containing the text captured in the first group.
Do not enable . matches newline option. (?s) will make the next . match any chars including line break chars, it is an inline DOTALL modifier variant while the previous ones will still match all chars but line break chars.
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
Assuming (.+td+t.+tdt.+td.+) matches the point after which you want to remove everything in the file to its end, you may append (?s).* to your pattern and replace with $1, a placeholder containing the text captured in the first group.
Do not enable . matches newline option. (?s) will make the next . match any chars including line break chars, it is an inline DOTALL modifier variant while the previous ones will still match all chars but line break chars.
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
answered Nov 22 at 12:43
Wiktor Stribiżew
305k16124201
305k16124201
1
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
add a comment |
1
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
1
1
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
Thank you all for your help guys. This is perfect!
– James Upson
Nov 22 at 13:01
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429744%2fdeleting-everything-after-matched-line%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please, edit your question and add sample text and expected result.
– Toto
Nov 22 at 11:42
(.+td+t.+tdt.+td.+)does not matchRow Count 278017. What did you mean to say? Also, see Remove everything except a certain pattern. If the files are short, this solution might do what you need.– Wiktor Stribiżew
Nov 22 at 11:42
Do you want to delete all until the end of the file? Or other limit? And what about everything that is present before? Are there linebreak somewhere or is it a single line?
– Toto
Nov 22 at 12:32
Is "Find what:
Row Count.+", "Replace with:LEAVE EMPTY" working for you? Don't forget to check. matches newline– Toto
Nov 22 at 12:37
Try
(?s)^Row Count.*. Are thosetTABs or just two char sequences? BTW, if they are tabs you may use your pattern like(.+td+t.+tdt.+td.+)R(?s).*and replace with$1.– Wiktor Stribiżew
Nov 22 at 12:38