• Login
Community
  • Login

In each line, how to delete everything after the second occurrence of the slash?

Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
regexregexregex occurance
2 Posts 2 Posters 666 Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    mplusplus
    last edited by Aug 23, 2021, 9:40 PM

    Hi there
    My CSV file is like the sample below. In each line, how to delete everything after the second occurrence of the slash? E.g.:

    /Secure Files/2019 Docs
    /IT and Security/Phil’s Documents/Documents/New Data/Commissions
    /Agency Contracting (External)/Senior Services

    Above will become

    2019 Docs
    Phil’s Documents/Documents/New Data/Commissions
    Senior Services

    Thank you so much.

    P 1 Reply Last reply Aug 23, 2021, 10:09 PM Reply Quote 0
    • P
      PeterJones @mplusplus
      last edited by Aug 23, 2021, 10:09 PM

      @mplusplus

      You say “after”, but then your example shows deleting everything before and including. I will assume your data, not your description, are correct.

      FIND = (?-s)^(?:.*?/){2} finds two groups of anything (zero or more characters) up to a slash and the slash itself
      REPLACE = leave empty
      SEARCH MODE = regular expression

      3beb0b3a-c1a8-474a-9c52-20aead7eb6b0-image.png

      1 Reply Last reply Reply Quote 1
      1 out of 2
      • First post
        1/2
        Last post
      The Community of users of the Notepad++ text editor.
      Powered by NodeBB | Contributors