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



  • 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.



  • @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