Posts by Gigliotti • 61 points
12 posts
-
0
votes1
answer74
viewsA: Summarizing birthday girls by month (SQL)
Good morning Bea! To bring the fields in a Count considering the nulls and giving the value zeroed if I have nothing there is the function COALESCE, because I believe it will be able to help you.…
-
-1
votes1
answer31
viewsQ: Simple doubt in JS - imput to textarea
I have a question to know if I can continue a project I got ready but this with some problems. the problem is that the whole project is returning to the values that are inserted into the HTML by the…
-
1
votes1
answer67
viewsA: Where am I going wrong on this select?
Good afternoon Robert. Maybe the problem is that Group By is using the name of the renamed columns and within the same query you have to use the exact From fields you are using. If you separate the…
-
1
votes2
answers788
viewsA: Problem with CASE WHEN SQL-SERVER
Within Case in SQL it is not possible to generate a column with numeric and text values as a single answer. That is, in your code if the VALUE is greater than 0 it generates a numeric result and if…
-
1
votes1
answer79
viewsQ: Code is skipping lines - Python
Good afternoon! I would like a help in my project that seeks words (file: Variables.txt) inside of another file (Answers.txt) and marks if you find a word. But skipping a few sentences leaving blank…
-
0
votes1
answer54
viewsQ: For i uses only the last variable - Python
Good morning! I am with a project that I am improving and would like to make a For i to run all variables within the project, but when running it applies the project only to the last variable. Code:…
-
1
votes1
answer619
viewsQ: Assign text in TXT file to a variable
Good morning! I am running a project that is working normally, but I would like to automate it more to gain time in operation. In case my project takes in a text file the main words I described…
-
0
votes1
answer1421
viewsA: Line Breaking in txt file - Python
I found out also for this case! Linux = ' n' Windows = ' n r' In this case the code stays this way: f = open(r"C:\Users\guilgig\Desktop\test.txt", "w") with…
-
0
votes1
answer1421
viewsQ: Line Breaking in txt file - Python
I am with a file selects the main words cited in the code I prepared. Put it in my file .txt it loses the line breaking that would be the most important for this document. Code: f =…
-
0
votes2
answers375
viewsA: Export process information to a . txt - Python
Guys I managed to do this first part, now I have a problem of breaking lines, I should break every variable made, but everything comes in the same line. Answer: f =…
-
0
votes2
answers375
viewsQ: Export process information to a . txt - Python
Good morning! I have a problem exporting the information that my process is generating. Currently I copy everything in mine print and paste it into a txt file, but I’d like to take this manual…
-
0
votes2
answers231
viewsQ: Highlight main words of a text in order of a ready list
I have a very basic basis that I would like to highlight the main words of each line of a prioritization list, example: Groundwork: Bom dia que dia lindo vamos embora vamos chutar o dia…