Forum Discussion
Solved
count back slash
Hi Everybody, I have a table with a column "folder path". It has values like the following:(examples) C:\koorosh\apple\documents C:\mac\user C:\iphone\data\package\app I want to find the numbe...
Easy enough,
koorosh Also, your orginal formula has 2 syntax errors in it, here is the correct version:
List.Count(Text.Split([folder path],"\"))M is case sensitive so Text.Split, not Text.split and you ended your Text.Split early with an errant )
Hi Grep, please check the above result!
koorosh Simple fix, just subtract 1:
List.Count(Text.Split([Column1],"\")) - 1Thanks Greg. I knew simple fix . I just let you know the result
