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 659 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.
    • mplusplusM
      mplusplus
      last edited by

      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.

      PeterJonesP 1 Reply Last reply Reply Quote 0
      • PeterJonesP
        PeterJones @mplusplus
        last edited by

        @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
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors