Posts by Marcos Correia • 123 points
6 posts
-
0
votes1
answer72
viewsQ: Pick string value from txt
I have in a txt that is mirror of a tax printer, I would like to take the COO number corresponding only to Z REDUCTION, in the example below would like to catch only the value 031717. 02/01/2014…
-
5
votes1
answer76
viewsQ: Regular Expression to clone a value in a field
I have the following values: PRO|00000001|GASOLINA ADITIVADA|0101001|27101259| I’d like an expression that changes values and stays that way: PRO|00000001|GASOLINA ADITIVADA|00000001|27101259| I…
regexasked Marcos Correia 123 -
-1
votes1
answer1839
viewsQ: SQL To Count If Greater Than 1
My problem is this: I have to make a condition if the SEQ_VENDA has more than 001 NUMERO, it bring the SELECT data. And if you only have 1 NUMBER for SEQ_VENDA do not bring in SQL…
-
1
votes2
answers41
viewsQ: Format result of time
I have the following fields: I would like to format the result of my following Query: SELECT TIMEDIFF(primeiraSaida, primeiraEntrada) + TIMEDIFF(segundaSaida, segundaEntrada) FROM pontoentradasaida…
mysqlasked Marcos Correia 123 -
6
votes2
answers2983
viewsQ: How to exclude a certain group from the regular expression
I have a tax file that comes with the following information on the line: Ex:. OCF|DINHEIRO|160.12|12 To fix it I have to erase a part, and the right one would be: OCF|DINHEIRO|160.12 Then I started…
regexasked Marcos Correia 123 -
0
votes2
answers98
viewsQ: Select data from three SQL tables
I am trying to join data from three tables using this sql: SELECT cod_nota, cupom, valor_contrato, valor_cadastro, data_emissao FROM cupons_nota, vendas, notas_fiscais WHERE cupons_nota.cupom =…