Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Count textcodes in a combined column

Hello everyeone,   I have created a combined column in my table which contains textcodes from multiple columns. It looks like this :   RCOM; RPOT; RAM*; RBC*; RCOM   I would like to be able to ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    Yes, the formula below should work in this scenario. :smileyhappy:

     

    =List.Count(List.PositionOfAny(List.Transform(Text.Split(Text.Trim([Column1]),";"),each Text.Start( _ , 4)),{"RCOM"},Occurrence.All))

     

    Regards

Anonymous's avatar
Anonymous
Not applicable
9 years ago

It works ! Thanks v-ljerr-msft!

 

Do you think it's possible to do this on partial parts of text ?

 

If i have for example RCOM01, RCOM02, RCOM03, i would like to be able to count the number of times when "RCOM" appears...

 

Thank you again :)

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Yes, the formula below should work in this scenario. :smileyhappy:

 

=List.Count(List.PositionOfAny(List.Transform(Text.Split(Text.Trim([Column1]),";"),each Text.Start( _ , 4)),{"RCOM"},Occurrence.All))

 

Regards