Post reply

location address without file name

  • November 3, 2020 at 4:11 pm

    #3803931

    If my column contains these values.

    C:\AABCD\EDFG\RFG\MyDB123.bak

    D:\RFG\MyDB1123.bak

    E:\AABCD\EDFG\MyDB1223.bak

    How do I select only these in my output

    C:\AABCD\EDFG\RFG

    D:\RFG

    E:\AABCD\EDFG

    Thanks

  • November 3, 2020 at 4:16 pm

    #3803934

    Really? >8,000 points and you still cross-post!

    Answers here, please.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 3, 2020 at 5:03 pm

    #3803961

    this was mistake.How do I take this post down or mark it as duplicate ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply