Power Query Count Certain Characters

[hatstand]

Hi All,

I’m stuck on what I think is a simple question. In Power query I am reading the contents of a folder and all of the sub folders. I'm now trying to return the number of “\” in the Folder Path to give me a ‘Level’.
What I can’t work out is how to count the “\” in paths. Any ideas?

 

[GraH]

Hi,

Perhaps this works as a custom column formula:

=List.Count(List.Select(Text.ToList([Folder Path]), each _ = "\"))

 

[hatstand]

That's exactly what I was after, very much appreciated. Thanks

 

[sandy666]

maybe extended version

Power Query How to list folder names only NOT files

Hello, I am fairly new to Power Query and have searched but can't find a solution - every thing I find is related to listing files, not folders. Is it possible for power query to just list folder names from a path? I can list all files with the path and extract the folder name but removing the...

www.mrexcel.com