Forum Discussion

koorosh's avatar
koorosh
Icon for Post Partisan rankPost 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,

koorosh's avatar
koorosh
Icon for Post Partisan rankPost Partisan
2 years ago

Hi Grep, please check the above result!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

koorosh Simple fix, just subtract 1:

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

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