Forum Discussion
Count words
Dá uma olhada no arquivo: Download PBIX na aba 2.
Eu inclui outras linhas, com tamanhos diferentes pra testar.
Hi Camargos88,
I tried here this measure, but without sucess.
Let me show you one example that I need ! I need create two column , one to count the SDD and other to count HDD like the example below:
| TEXT COLUMN | COUNT SSD | COUNT HDD |
| <br/>MediaType : SSD<br/><br/>MediaType : HDD<br/><br/>MediaType : HDD<br/> | 1 | 2 |
| <br/>MediaType : SSD<br/><br/>MediaType : SSD<br/><br/>MediaType : SSD<br/> | 3 | 0 |
| <br/>MediaType : HDD<br/><br/>MediaType : HDD<br/><br/>MediaType : HDD<br/> | 0 | 3 |
| <br/>MediaType : SSD<br/><br/>MediaType : SSD<br/><br/>MediaType : SSD<br/> | 3 | 0 |
| <br/>MediaType : HDD<br/><br/>MediaType : SSD<br/><br/>MediaType : SSD<br/> | 2 | 1 |
Thanks
Hi LESPINOLA ,
Check the uploaded file, I did some work on the column to transform it on columns, so you can easily filter it.
Also it`s important to know exactly if the column has break lines or another special characters, so we can transform it.
Hi camargos88 ,
Unfortunately the lines have no defined patterns and sizes to be able to divide the columns.
I have to identify the SSD word inside the text and count how many times it appears.
Thanks
Vou dar uma olhada nas linhas que mandou. Se as linhas tem <br/><br/> já é um padrão para a quebra.