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
Why didn’t Eve recognize the little cockroach as a living organism?
Is VPN a layer 3 concept?
How do researchers send unsolicited emails asking for feedback on their works?
Justification failure in beamer enumerate list
How old is Nick Fury?
Do I need an EFI partition for each 18.04 ubuntu I have on my HD?
Is there any common country to visit for uk and schengen visa?
Why doesn't the chatan sign the ketubah?
When did hardware antialiasing start being available?
How are passwords stolen from companies if they only store hashes?
Do people actually use the word "kaputt" in conversation?
Why does Surtur say that Thor is Asgard's doom?
Single word to change groups
Unfrosted light bulb
Extraneous elements in "Europe countries" list
Determine voltage drop over 10G resistors with cheap multimeter
PTIJ: Which Dr. Seuss books should one obtain?
What is it called when someone votes for an option that's not their first choice?
Writing in a Christian voice
Animating wave motion in water
Why doesn't the fusion process of the sun speed up?
Does convergence of polynomials imply that of its coefficients?
Was World War I a war of liberals against authoritarians?
pipe commands inside find -exec?
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
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
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
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
asked Mar 6 at 23:07
kodebugkodebug
21
asked Mar 6 at 23:07
kodebugkodebug
21
asked Mar 6 at 23:07
kodebugkodebug
21
asked Mar 6 at 23:07
kodebugkodebug
21
21
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
39.3k41743
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
);
);
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
39.3k41743
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
39.3k41743
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
39.3k41743
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
39.3k41743
answered Mar 6 at 23:22
blhsingblhsing
39.3k41743
answered Mar 6 at 23:22
blhsingblhsing
39.3k41743
answered Mar 6 at 23:22
blhsingblhsing
39.3k41743
39.3k41743
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 |
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