How do I change two letters closest to a string and one letter immediately after a string using Notepad++?
I have a list of emails, and I want to change the two letters before "@" and the first letter after "@" using Notepad++.
For example:
username@yourdomain.com
becomes
userna**@*ourdomain.com
notepad++
New contributor
add a comment |
I have a list of emails, and I want to change the two letters before "@" and the first letter after "@" using Notepad++.
For example:
username@yourdomain.com
becomes
userna**@*ourdomain.com
notepad++
New contributor
9
Just an obvious remark, the concrete example you gave shows how useless this pattern would be to anonymize email addresses. It’s usually better like x******@y***.com
– eckes
2 days ago
@eckes would that even be possible in N++?
– WELZ
2 days ago
3
@WELZ Yes but its more work, a half working sample would(.)[^@]*@([^.]).*(.[a-z]+)
use 3 capture groups which you can address in the replace with string:1***@2***3
- uses a fixed number of mask characters but this is actually good.
– eckes
2 days ago
add a comment |
I have a list of emails, and I want to change the two letters before "@" and the first letter after "@" using Notepad++.
For example:
username@yourdomain.com
becomes
userna**@*ourdomain.com
notepad++
New contributor
I have a list of emails, and I want to change the two letters before "@" and the first letter after "@" using Notepad++.
For example:
username@yourdomain.com
becomes
userna**@*ourdomain.com
notepad++
notepad++
New contributor
New contributor
edited yesterday
Peter Mortensen
8,376166185
8,376166185
New contributor
asked 2 days ago
loveman2019loveman2019
493
493
New contributor
New contributor
9
Just an obvious remark, the concrete example you gave shows how useless this pattern would be to anonymize email addresses. It’s usually better like x******@y***.com
– eckes
2 days ago
@eckes would that even be possible in N++?
– WELZ
2 days ago
3
@WELZ Yes but its more work, a half working sample would(.)[^@]*@([^.]).*(.[a-z]+)
use 3 capture groups which you can address in the replace with string:1***@2***3
- uses a fixed number of mask characters but this is actually good.
– eckes
2 days ago
add a comment |
9
Just an obvious remark, the concrete example you gave shows how useless this pattern would be to anonymize email addresses. It’s usually better like x******@y***.com
– eckes
2 days ago
@eckes would that even be possible in N++?
– WELZ
2 days ago
3
@WELZ Yes but its more work, a half working sample would(.)[^@]*@([^.]).*(.[a-z]+)
use 3 capture groups which you can address in the replace with string:1***@2***3
- uses a fixed number of mask characters but this is actually good.
– eckes
2 days ago
9
9
Just an obvious remark, the concrete example you gave shows how useless this pattern would be to anonymize email addresses. It’s usually better like x******@y***.com
– eckes
2 days ago
Just an obvious remark, the concrete example you gave shows how useless this pattern would be to anonymize email addresses. It’s usually better like x******@y***.com
– eckes
2 days ago
@eckes would that even be possible in N++?
– WELZ
2 days ago
@eckes would that even be possible in N++?
– WELZ
2 days ago
3
3
@WELZ Yes but its more work, a half working sample would
(.)[^@]*@([^.]).*(.[a-z]+)
use 3 capture groups which you can address in the replace with string: 1***@2***3
- uses a fixed number of mask characters but this is actually good.– eckes
2 days ago
@WELZ Yes but its more work, a half working sample would
(.)[^@]*@([^.]).*(.[a-z]+)
use 3 capture groups which you can address in the replace with string: 1***@2***3
- uses a fixed number of mask characters but this is actually good.– eckes
2 days ago
add a comment |
2 Answers
2
active
oldest
votes
I want to change the two letters before "@" and the first letter after "@"
Menu "Search" > "Replace" (or Ctrl + H)
Set "Find what" to
..@.
Set "Replace with" to
**@*
Enable "Regular expression"
Click "Replace All"
Before:
username@yourdomain.com
After:
userna**@*ourdomain.com
Further reading
- How to use regular expressions in Notepad++ (tutorial)
- Notepad++: A guide to using regular expressions and extended search mode
- Regular Expressions Tutorial
- RegExr: Learn, Build, & Test RegEx
- regex101: Online regex tester and debugger
- RegExper: Regular Expression Visualiser
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
7
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
I'd say it should be.?.@.
as there might not be two characters before @.
– n0rd
yesterday
1
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
add a comment |
You can do this by using a regex search/replace.
At the bottom, select Regular Expression.
In the Search for entry, you type in: ..@.
In the Replace with, you type in **@*
Then press the button Replace All
This works because Regex searches will only replace if its search criteria matches exactly. The match is explained as follows:
..@.
There are 3 dots and an @
:
@
has no special meaning in regex so it means a literal @.
.
means any character, exactly once. By writing..
it means 2 characters of any kind, as long as there are 2 characters.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
loveman2019 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%2fsuperuser.com%2fquestions%2f1414191%2fhow-do-i-change-two-letters-closest-to-a-string-and-one-letter-immediately-after%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I want to change the two letters before "@" and the first letter after "@"
Menu "Search" > "Replace" (or Ctrl + H)
Set "Find what" to
..@.
Set "Replace with" to
**@*
Enable "Regular expression"
Click "Replace All"
Before:
username@yourdomain.com
After:
userna**@*ourdomain.com
Further reading
- How to use regular expressions in Notepad++ (tutorial)
- Notepad++: A guide to using regular expressions and extended search mode
- Regular Expressions Tutorial
- RegExr: Learn, Build, & Test RegEx
- regex101: Online regex tester and debugger
- RegExper: Regular Expression Visualiser
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
7
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
I'd say it should be.?.@.
as there might not be two characters before @.
– n0rd
yesterday
1
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
add a comment |
I want to change the two letters before "@" and the first letter after "@"
Menu "Search" > "Replace" (or Ctrl + H)
Set "Find what" to
..@.
Set "Replace with" to
**@*
Enable "Regular expression"
Click "Replace All"
Before:
username@yourdomain.com
After:
userna**@*ourdomain.com
Further reading
- How to use regular expressions in Notepad++ (tutorial)
- Notepad++: A guide to using regular expressions and extended search mode
- Regular Expressions Tutorial
- RegExr: Learn, Build, & Test RegEx
- regex101: Online regex tester and debugger
- RegExper: Regular Expression Visualiser
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
7
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
I'd say it should be.?.@.
as there might not be two characters before @.
– n0rd
yesterday
1
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
add a comment |
I want to change the two letters before "@" and the first letter after "@"
Menu "Search" > "Replace" (or Ctrl + H)
Set "Find what" to
..@.
Set "Replace with" to
**@*
Enable "Regular expression"
Click "Replace All"
Before:
username@yourdomain.com
After:
userna**@*ourdomain.com
Further reading
- How to use regular expressions in Notepad++ (tutorial)
- Notepad++: A guide to using regular expressions and extended search mode
- Regular Expressions Tutorial
- RegExr: Learn, Build, & Test RegEx
- regex101: Online regex tester and debugger
- RegExper: Regular Expression Visualiser
I want to change the two letters before "@" and the first letter after "@"
Menu "Search" > "Replace" (or Ctrl + H)
Set "Find what" to
..@.
Set "Replace with" to
**@*
Enable "Regular expression"
Click "Replace All"
Before:
username@yourdomain.com
After:
userna**@*ourdomain.com
Further reading
- How to use regular expressions in Notepad++ (tutorial)
- Notepad++: A guide to using regular expressions and extended search mode
- Regular Expressions Tutorial
- RegExr: Learn, Build, & Test RegEx
- regex101: Online regex tester and debugger
- RegExper: Regular Expression Visualiser
answered 2 days ago
DavidPostill♦DavidPostill
107k27234268
107k27234268
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
7
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
I'd say it should be.?.@.
as there might not be two characters before @.
– n0rd
yesterday
1
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
add a comment |
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
7
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
I'd say it should be.?.@.
as there might not be two characters before @.
– n0rd
yesterday
1
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
DavidPostill thanks,it worked for me.
– loveman2019
2 days ago
7
7
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
@loveman2019 Do you need more help? If this answered your question, please don't forget to accept the answer by clicking the accept button (the tick ✓ button).
– DavidPostill♦
2 days ago
I'd say it should be
.?.@.
as there might not be two characters before @.– n0rd
yesterday
I'd say it should be
.?.@.
as there might not be two characters before @.– n0rd
yesterday
1
1
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
@n0rd The question specified two characters, but you are correct if there is only one.
– DavidPostill♦
yesterday
add a comment |
You can do this by using a regex search/replace.
At the bottom, select Regular Expression.
In the Search for entry, you type in: ..@.
In the Replace with, you type in **@*
Then press the button Replace All
This works because Regex searches will only replace if its search criteria matches exactly. The match is explained as follows:
..@.
There are 3 dots and an @
:
@
has no special meaning in regex so it means a literal @.
.
means any character, exactly once. By writing..
it means 2 characters of any kind, as long as there are 2 characters.
add a comment |
You can do this by using a regex search/replace.
At the bottom, select Regular Expression.
In the Search for entry, you type in: ..@.
In the Replace with, you type in **@*
Then press the button Replace All
This works because Regex searches will only replace if its search criteria matches exactly. The match is explained as follows:
..@.
There are 3 dots and an @
:
@
has no special meaning in regex so it means a literal @.
.
means any character, exactly once. By writing..
it means 2 characters of any kind, as long as there are 2 characters.
add a comment |
You can do this by using a regex search/replace.
At the bottom, select Regular Expression.
In the Search for entry, you type in: ..@.
In the Replace with, you type in **@*
Then press the button Replace All
This works because Regex searches will only replace if its search criteria matches exactly. The match is explained as follows:
..@.
There are 3 dots and an @
:
@
has no special meaning in regex so it means a literal @.
.
means any character, exactly once. By writing..
it means 2 characters of any kind, as long as there are 2 characters.
You can do this by using a regex search/replace.
At the bottom, select Regular Expression.
In the Search for entry, you type in: ..@.
In the Replace with, you type in **@*
Then press the button Replace All
This works because Regex searches will only replace if its search criteria matches exactly. The match is explained as follows:
..@.
There are 3 dots and an @
:
@
has no special meaning in regex so it means a literal @.
.
means any character, exactly once. By writing..
it means 2 characters of any kind, as long as there are 2 characters.
edited 2 days ago
Ismael Miguel
1871215
1871215
answered 2 days ago
LPChipLPChip
36.3k55487
36.3k55487
add a comment |
add a comment |
loveman2019 is a new contributor. Be nice, and check out our Code of Conduct.
loveman2019 is a new contributor. Be nice, and check out our Code of Conduct.
loveman2019 is a new contributor. Be nice, and check out our Code of Conduct.
loveman2019 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1414191%2fhow-do-i-change-two-letters-closest-to-a-string-and-one-letter-immediately-after%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
9
Just an obvious remark, the concrete example you gave shows how useless this pattern would be to anonymize email addresses. It’s usually better like x******@y***.com
– eckes
2 days ago
@eckes would that even be possible in N++?
– WELZ
2 days ago
3
@WELZ Yes but its more work, a half working sample would
(.)[^@]*@([^.]).*(.[a-z]+)
use 3 capture groups which you can address in the replace with string:1***@2***3
- uses a fixed number of mask characters but this is actually good.– eckes
2 days ago