Extracting Characters to the left of a "\"

[BrianHillsboro]

I am trying to extract a folder path to the left of a "|". I have seen forums of how to do it by selecting the number of characters, but my list contains a folder path to a .mpg file with different lengths of folder paths leading to that video. Two different examples:

[TABLE="width: 1320"]
<tbody>[TR]
[TD="width: 1320"]\\bantha\pwvideo2$\PipeTech\2015\209245-209246-11 04 2015-2 39 PM\209245-209246-11 04 2015-2 39 PM.mpg

\\bantha\pwvideo2$\PipeTech\2012\SD30E\221663-22168402 21 20128 27 AM\221663-22168402 21 20128 27 AM.mpg

I would like to extract everything in a new column so that it just includes the folder path to the video, such as:

[TABLE="width: 1320"]
<tbody>[TR]
[TD="width: 1320"]\\bantha\pwvideo2$\PipeTech\2015\209245-209246-11 04 2015-2 39 PM

\\bantha\pwvideo2$\PipeTech\2012\SD30E\221663-22168402 21 20128 27 AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[njimack]

=left(a1,find("#",substitute(a1,"\","#",len(a1)-len(substitute(a1,"\",""))))-1)

 

[Peter_SSs]

Or this?

Excel Workbook
	A	B
1
2	\\bantha\pwvideo2$\PipeTech\2015\209245-209246-11 04 2015-2 39 PM\209245-209246-11 04 2015-2 39 PM.mpg	\\bantha\pwvideo2$\PipeTech\2015\209245-209246-11 04 2015-2 39 PM
3	\\bantha\pwvideo2$\PipeTech\2012\SD30E\221663-22168402 21 20128 27 AM\221663-22168402 21 20128 27 AM.mpg	\\bantha\pwvideo2$\PipeTech\2012\SD30E\221663-22168402 21 20128 27 AM
Extract Path

 

[BrianHillsboro]

Thank you, worked perfectly