Find quotes and backslash



  • Hi,
    I would like to use Find & Replace the following database texts:

    userid=“NewPC\User\Maya”
    userid=“Computer\Home”
    userid=“XP\Admin”
    .
    .
    .
    . etc.

    only to: userid=“Private_001”

    The creationid=backslash"[\w ]*backslash" regex command is not good, because i cant find backslash instances. (backslash is missing here in view mode)

    I now that the finding method is tricky, i would like you to help me.



  • @Mária-Csabai

    You could find your desired text with a regular expression in the Find-what zone of:

    userid=“(NewPC\\User\\Maya|Computer\\Home|XP\\Admin)”

    Hope that helps you…

    BTW I have no idea what The creationid=backslash"[\w ]*backslash" regex command is not good, because i cant find backslash instances. (backslash is missing here in view mode) means…



  • Dear Scott,
    first thank you for your quick help!

    The merged code works perfectly!

    But, there are approx. 46 users in 270000 lines and therefore should i combine the solution with the * joker character :-)

    Sincerely, Maya



  • @Mária-Csabai said:

    But, there are approx. 46 users in 270000 lines and therefore should i combine the solution with…

    I can’t tell if you still have a problem you need help with or not… :-(



  • @Mária-Csabai you can send private link of file for more help



  • @Scott-Sumner
    Dear Scott, thank you for your help, it worked really well.
    I am a beginner and this task is complex, I need to learn the regex commands.
    I do not want to ask, first, I look carefully at the problem.
    Thanks, and if you can, I’ll ask you more.



  • Dear Friends,
    with the specified search criteria, userid=“(NewPC\User\Maya|Computer\Home|XP\Admin)”
    I could replace all users. There were only 21 variations and I could find it and type it.

    Thanks again for everyone!


Log in to reply