Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

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

    Help wanted · · · – – – · · ·
    regex notepad++ regex regex occurance
    2
    2
    70
    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.
    • mplusplus
      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.

      PeterJones 1 Reply Last reply Reply Quote 0
      • PeterJones
        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
        Copyright © 2014 NodeBB Forums | Contributors