Forum Discussion
koorosh
Post Partisan
Post Partisancount 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,
Greg_Deckler
Community Champion
Community Championkoorosh 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 )
kooroshPost Partisan
Post PartisanHi Grep, please check the above result!
- Greg_Deckler
koorosh Simple fix, just subtract 1:
List.Count(Text.Split([Column1],"\")) - 1- koorosh
Thanks Greg. I knew simple fix . I just let you know the result