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.

     

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.