Forum Discussion

koorosh's avatar
koorosh
Post Partisan
2 years ago
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...
Need Help
  • ThxAlot's avatar
    ThxAlot
    2 years ago

    Easy enough,

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

koorosh Simple fix, just subtract 1:

List.Count(Text.Split([Column1],"\")) - 1
koorosh's avatar
koorosh
Post Partisan
2 years ago

Thanks Greg. I knew simple fix . I just let you know the result