Truncate text after final "\" character

[quinla01]

Hi, 

I have a table with a 1000's of rows of file paths. I'm only intersted in folders.

Say i have a folder path:

s:\shared\folder1\folder2\ThisFile.txt

And i want to drop the filename:

s:\shared\folder1\folder2\

Any ideas? I guess the logic is drop all text after the final "/" but not sure how to do it. 

Thanks

Andrew

[ImkeF]

You'd extract the Text.BeforeDelimiter "\" with option "From the end of the input" and then add it back like so: & "\".

[quinla01]

Hi, 

Looks like that may work. How do I find that windows? 

Thanks