Posts by fercs89 • 37 points
8 posts
-
0
votes0
answers17
viewsQ: Condition for file name
I need to make the following condition if the file name, which is a . json, has the characters VG, AP or GM pandas: if name_arquivo.str.contains('_VG_') or name_arquivo.str.contains('_AP_') or…
-
-1
votes1
answer44
views -
0
votes2
answers1538
viewsA: Return 3 months previous from day 1
Another way I got: SELECT Z.ID_CONTA, W.ID_TRANSACAO, Y.DS_TIPO_TRANSACAO, W.DT_ORIGEM, W.VL_TRANSACAO FROM T_CONTA Z LEFT JOIN W_TRANSACAO W ON Z.ID_CONTA = W.ID_CONTA LEFT JOIN T_TIPOTRANSACAO Y…
-
1
votes2
answers1538
viewsQ: Return 3 months previous from day 1
Every Friday I need to generate a report that brings me transactions made in the last three months. However, I have to pick up from the 1st of each month, for example, we are in the 9th month, so I…
-
0
votes2
answers131
viewsA: Whiten figure VBA Excel
Good morning @danieltakeshi. It wasn’t a single image. What I did was create a white rectangle with 30% transparency, and then I recorded the macro by moving it behind the figure. got that way:…
-
0
votes2
answers131
viewsQ: Whiten figure VBA Excel
Good afternoon. I need a macro to clear a figure, located in the spreadsheet, and reverse the coloring. Excel does not save the macro when I change the settings in the "Format" tab. I have already…
-
1
votes1
answer76
viewsQ: Temporary table with underscore
I am trying in my service to create temporary tables as I have always learned, putting # in front of the name I want. But I don’t know what happens when I create one, it puts a huge underscore and…
-
1
votes1
answer2740
viewsQ: Maximum SQL date
I have the following table T_PGTOS_ADESAO: Adesão | Tipo Adesão | Data Vencimento Boleto | Data Pgto Boleto 12247 | Cartão | 20-03-2018 | 03-03-2018 38497 | Boleto | 15-05-2018 | 10-05-2018 48289 |…