location address without file name

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  November 3, 2020 at 4:16 pm

  #3803934

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

  Answers here, please.

  ---

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  November 3, 2020 at 5:03 pm

  #3803961

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