Removing duplicate IP's from a list with no concern of variables after them2019 Community Moderator ElectionRegex to find/remove duplicate linePowerShell: Import-CSV with no headers and remove partial duplicate linesRemoving duplicate rows from Notepad++Linux Bash commands to remove duplicates from a CSV fileRemove duplicate keys (and their values) from a dictionary PYTHONRemove duplicate line only contain specific stringRemove duplicates from csv and count them in JavaPython remove duplicates from the list?Removes duplicate lines from files recursivelyremove duplicate from list and check if IP's from one list in another list
Trocar background-image com delay via jQuery
Is this Paypal Github SDK reference really a dangerous site?
Logistic regression BIC: what's the right N?
Are small insurances worth it?
Traveling to heavily polluted city, what practical measures can I take to minimize impact?
Finding the minimum value of a function without using Calculus
What is better: yes / no radio, or simple checkbox?
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
What do you call someone who likes to pick fights?
How do I increase the number of TTY consoles?
Do black holes violate the conservation of mass?
How should I solve this integral with changing parameters?
What does the Digital Threat scope actually do?
If sound is a longitudinal wave, why can we hear it if our ears aren't aligned with the propagation direction?
Writing text next to a table
Do Paladin Auras of Differing Oaths Stack?
"If + would" conditional in present perfect tense
Was it really inappropriate to write a pull request for the company I interviewed with?
Use Mercury as quenching liquid for swords?
Why does Central Limit Theorem break down in my simulation?
Is it possible to clone a polymorphic object without manually adding overridden clone method into each derived class in C++?
What is Tony Stark injecting into himself in Iron Man 3?
How can I portion out frozen cookie dough?
When an outsider describes family relationships, which point of view are they using?
Removing duplicate IP's from a list with no concern of variables after them
2019 Community Moderator ElectionRegex to find/remove duplicate linePowerShell: Import-CSV with no headers and remove partial duplicate linesRemoving duplicate rows from Notepad++Linux Bash commands to remove duplicates from a CSV fileRemove duplicate keys (and their values) from a dictionary PYTHONRemove duplicate line only contain specific stringRemove duplicates from csv and count them in JavaPython remove duplicates from the list?Removes duplicate lines from files recursivelyremove duplicate from list and check if IP's from one list in another list
I have this kind of list (csv):
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.1,"10","2019-02-12 16:20:28"
100.100.100.2,"10","2019-02-12 16:20:26"
100.100.100.2,"10","2019-02-12 16:20:27"
So I Would like to know the best solution with RegExp to remove duplicate IP's from a list (by removing whole line). Values after IP should have no importance. First occurrence of IP might as well be the one that stays.
So the output should be:
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.2,"10","2019-02-12 16:20:26"
I am using Notepad++
regex csv
asked Mar 6 at 23:07
kodebugkodebug
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have this kind of list (csv):
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.1,"10","2019-02-12 16:20:28"
100.100.100.2,"10","2019-02-12 16:20:26"
100.100.100.2,"10","2019-02-12 16:20:27"
So I Would like to know the best solution with RegExp to remove duplicate IP's from a list (by removing whole line). Values after IP should have no importance. First occurrence of IP might as well be the one that stays.
So the output should be:
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.2,"10","2019-02-12 16:20:26"
I am using Notepad++
regex csv
asked Mar 6 at 23:07
kodebugkodebug
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to Stack Overflow. Check the Stack Overflow's help on asking questions first, please. Focus on What topics can I ask about here, What types of questions should I avoid asking?, How to ask a good question, How to create a Minimal, Complete, and Verifiable example and Stack Overflow question checklist.
– Dawid Ferenczy
Mar 6 at 23:25
add a comment |
I have this kind of list (csv):
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.1,"10","2019-02-12 16:20:28"
100.100.100.2,"10","2019-02-12 16:20:26"
100.100.100.2,"10","2019-02-12 16:20:27"
So I Would like to know the best solution with RegExp to remove duplicate IP's from a list (by removing whole line). Values after IP should have no importance. First occurrence of IP might as well be the one that stays.
So the output should be:
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.2,"10","2019-02-12 16:20:26"
I am using Notepad++
regex csv
asked Mar 6 at 23:07
kodebugkodebug
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have this kind of list (csv):
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.1,"10","2019-02-12 16:20:28"
100.100.100.2,"10","2019-02-12 16:20:26"
100.100.100.2,"10","2019-02-12 16:20:27"
So I Would like to know the best solution with RegExp to remove duplicate IP's from a list (by removing whole line). Values after IP should have no importance. First occurrence of IP might as well be the one that stays.
So the output should be:
100.100.100.1,"10","2019-02-12 16:20:23"
100.100.100.2,"10","2019-02-12 16:20:26"
I am using Notepad++
regex csv
regex csv
asked Mar 6 at 23:07
kodebugkodebug
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 6 at 23:07
kodebugkodebug
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 6 at 23:07
kodebugkodebug
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 6 at 23:07
kodebugkodebug
21
asked Mar 6 at 23:07
kodebugkodebug
21
21
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
kodebug is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Welcome to Stack Overflow. Check the Stack Overflow's help on asking questions first, please. Focus on What topics can I ask about here, What types of questions should I avoid asking?, How to ask a good question, How to create a Minimal, Complete, and Verifiable example and Stack Overflow question checklist.
– Dawid Ferenczy
Mar 6 at 23:25
add a comment |
1
Welcome to Stack Overflow. Check the Stack Overflow's help on asking questions first, please. Focus on What topics can I ask about here, What types of questions should I avoid asking?, How to ask a good question, How to create a Minimal, Complete, and Verifiable example and Stack Overflow question checklist.
– Dawid Ferenczy
Mar 6 at 23:25
1
1
Welcome to Stack Overflow. Check the Stack Overflow's help on asking questions first, please. Focus on What topics can I ask about here, What types of questions should I avoid asking?, How to ask a good question, How to create a Minimal, Complete, and Verifiable example and Stack Overflow question checklist.
– Dawid Ferenczy
Mar 6 at 23:25
Welcome to Stack Overflow. Check the Stack Overflow's help on asking questions first, please. Focus on What topics can I ask about here, What types of questions should I avoid asking?, How to ask a good question, How to create a Minimal, Complete, and Verifiable example and Stack Overflow question checklist.
– Dawid Ferenczy
Mar 6 at 23:25
add a comment |
1 Answer
1
active
oldest
votes
You can search with the following regex with the ". matches newline" option checked:
^(([^,]+).*?)^2,[^n]*(n|$)
and replace the matches with:
$1
Demo: https://regex101.com/r/j91kjJ/1
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
kodebug is a new contributor. Be nice, and check out our Code of Conduct.
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%2f55033617%2fremoving-duplicate-ips-from-a-list-with-no-concern-of-variables-after-them%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can search with the following regex with the ". matches newline" option checked:
^(([^,]+).*?)^2,[^n]*(n|$)
and replace the matches with:
$1
Demo: https://regex101.com/r/j91kjJ/1
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
add a comment |
You can search with the following regex with the ". matches newline" option checked:
^(([^,]+).*?)^2,[^n]*(n|$)
and replace the matches with:
$1
Demo: https://regex101.com/r/j91kjJ/1
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
add a comment |
You can search with the following regex with the ". matches newline" option checked:
^(([^,]+).*?)^2,[^n]*(n|$)
and replace the matches with:
$1
Demo: https://regex101.com/r/j91kjJ/1
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
You can search with the following regex with the ". matches newline" option checked:
^(([^,]+).*?)^2,[^n]*(n|$)
and replace the matches with:
$1
Demo: https://regex101.com/r/j91kjJ/1
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
answered Mar 6 at 23:22
blhsingblhsing
37.9k41641
37.9k41641
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
add a comment |
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
This only works if the appearances are consecutive, not if they are mixed up. I don't see any possibility to remove duplicates that are not consecutive in Notepad++.
– csabinho
Mar 7 at 0:11
add a comment |
kodebug is a new contributor. Be nice, and check out our Code of Conduct.
kodebug is a new contributor. Be nice, and check out our Code of Conduct.
kodebug is a new contributor. Be nice, and check out our Code of Conduct.
kodebug is a new contributor. Be nice, and check out our Code of Conduct.
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.
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%2f55033617%2fremoving-duplicate-ips-from-a-list-with-no-concern-of-variables-after-them%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
1
Welcome to Stack Overflow. Check the Stack Overflow's help on asking questions first, please. Focus on What topics can I ask about here, What types of questions should I avoid asking?, How to ask a good question, How to create a Minimal, Complete, and Verifiable example and Stack Overflow question checklist.
– Dawid Ferenczy
Mar 6 at 23:25