How do I change two letters closest to a string and one letter immediately after a string using Notepad++?












9















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









share|improve this question









New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 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















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









share|improve this question









New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 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








9


2






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









share|improve this question









New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












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++






share|improve this question









New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited yesterday









Peter Mortensen

8,376166185




8,376166185






New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









loveman2019loveman2019

493




493




New contributor




loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






loveman2019 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 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





    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












2 Answers
2






active

oldest

votes


















30














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"



    enter image description here




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






share|improve this answer
























  • 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



















8














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.






share|improve this answer

























    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.










    draft saved

    draft discarded


















    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









    30














    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"



      enter image description here




    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






    share|improve this answer
























    • 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
















    30














    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"



      enter image description here




    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






    share|improve this answer
























    • 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














    30












    30








    30







    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"



      enter image description here




    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






    share|improve this answer













    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"



      enter image description here




    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







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered 2 days ago









    DavidPostillDavidPostill

    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



















    • 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













    8














    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.






    share|improve this answer






























      8














      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.






      share|improve this answer




























        8












        8








        8







        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.






        share|improve this answer















        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.







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited 2 days ago









        Ismael Miguel

        1871215




        1871215










        answered 2 days ago









        LPChipLPChip

        36.3k55487




        36.3k55487






















            loveman2019 is a new contributor. Be nice, and check out our Code of Conduct.










            draft saved

            draft discarded


















            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            "Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)

            Alcedinidae

            RAC Tourist Trophy