Forum Discussion

LESPINOLA's avatar
LESPINOLA
New Member
6 years ago
Solved

Count words

Hi All,    I need to count the number of SSD from the cell below:   FriendlyName : Msft Virtual Disk SerialNumber : MediaType : SSD Size : 8589934592 FriendlyName : ST3320418AS SerialNumber ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    LESPINOLA ,

     

    Dá uma olhada no arquivo:  Download PBIX  na aba 2.

     

     

    Eu inclui outras linhas, com tamanhos diferentes pra testar.

     

camargos88's avatar
camargos88
Community Champion
6 years ago

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.

 

LESPINOLA's avatar
LESPINOLA
New Member
6 years ago

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

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    LESPINOLA ,

     

    Vou dar uma olhada nas linhas que mandou. Se as linhas tem <br/><br/> já é um padrão para a quebra.