Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Boa Tarde.!
Alguém poderia me dar uma explicação da função abaixo:
=SubStringCount(Concat(Campo_Tabela,'|'), 'A')
Muito Obrigado.
Renato
=SubStringCount(Concat(Campo_Tabela,'|'), 'A')
Let me divide in two different function...
Concat(Campo_Tabela,'|')
This will concatenate all/selected values of Campo_Tabela and the seperator is |
=SubStringCount(Concat(Campo_Tabela,'|'), 'A')
SubstringCount will check that from the above concatenation result will have 'A' inside or not... It is is there, it will give you 1 (=True) or 0 (=False)....
Hope this will clear your doubt..
=SubStringCount(Concat(Campo_Tabela,'|'), 'A')
Let me divide in two different function...
Concat(Campo_Tabela,'|')
This will concatenate all/selected values of Campo_Tabela and the seperator is |
=SubStringCount(Concat(Campo_Tabela,'|'), 'A')
SubstringCount will check that from the above concatenation result will have 'A' inside or not... It is is there, it will give you 1 (=True) or 0 (=False)....
Hope this will clear your doubt..
OK.!
Muito Obrigado.!!
Renato