Advertisements I would like to find a way to use an iterative loop (for or while) to remove quotes (") from a dataset like the following: "Macao,""China,Macao Special Administrative Region"",MAC I know that there is the following way to remove them, which is actually more efficient, but it is important that it is an iterative… Read More Loop to remove inverted commas (") in a dataset in bash
Advertisements So I am trying to run this function. CREATE OR REPLACE FUNCTION TableIteration() RETURNS TABLE(table_schema text, table_name text) LANGUAGE plpgsql AS $$ DECLARE tgt_schema varchar; list text[] := ARRAY[ "text1", "text2", "text3", "text4", "text5", "text6", "text7", "text8", "text9" ]; BEGIN FOREACH tgt_schema IN ARRAY list LOOP RETURN QUERY EXECUTE ‘SELECT t.table_schema :: text, t.table_name::text… Read More Concatenation with variable in function gives an error
Advertisements I have this string: Parameter1="Something related to this" Parameter2="Another value" Parameter3=’Single quotes are permitted’ Parameter4="Even HTML entities are permitted" I want to get this list: Parameter1=Something related to this Parameter2=Another value Parameter3=Single quotes are permitted Parameter4=Even HTML entities are permitted I tried this regex. But it’s not working: (\w+)=((‘|"|")).*((‘|"|")) How can I parse this… Read More How to parse a given key-value parameters string?
Advertisements I am receiving a very common error while trying to connect Microsoft SQL Server using pyodbc. I’ve tried the solutions suggested here before, but none of them solved my problem. import pyodbc conn = pyodbc.connect(‘Driver={SQL Server};’ ‘Server= server_name;’ ‘Database= database_name;’ ‘UID= user_id;’ ‘PWD= password;’) InterfaceError: (‘28000’, "[28000] [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed… Read More Fix "login failed for user.." error in connecting Microsoft SQL server in Python
Advertisements I have a large file: . .. … { "term": "Allow A to B", "to_zone" : ["inside"], "from_zone" : ["sys"], "source" : ["10.10.10.10/32"], "destination": ["20.20.20.20/32","30.30.30.30/32"], "source_user" : ["any"], "category" : ["any"], "application" : ["any"], "service" : ["application-default"], "source_hip" : ["any"], "destination_hip" : ["any"], "tag" : ["con"], "action" : "allow", "rule_type" : ["universal"], "group_tag" :… Read More Find and replace only if it matches a string in vi editor
Advertisements I want to make a authentication system with a simple key (string). If the key is correctly inputed, start the program. The problem is, that I have no idea how I code it so the program checks if the key is correct without a way seeing in as a user in the code. Can… Read More How can I code a secure authentication system in Python?
Advertisements I’m editing a csv file which contains hidden line breaks. When I apply the following php script, the line breaks are successfully removed from the entire file. $csvFileNew = str_replace(array("\r", "\n"), ”, $csvFileOld); But I only want to remove these line breaks from within certain sections of the file – between all occurrences of… Read More Removing line breaks between 2 different character sequences
Advertisements I am getting an error when I try to use where clause in the following query : SELECT creation_date FROM `bigquery-public-data.stackoverflow.stackoverflow_posts` WHERE creation_date BETWEEN 2021-08-01 AND 2021-08-31; Syntax error : No matching signature for operator BETWEEN for argument types: TIMESTAMP, INT64, INT64. Supported signature: (ANY) BETWEEN (ANY) AND (ANY) at [6:17] What is the… Read More Syntax error for Where clause in Bigquery
Advertisements I´m working on creating a list for a game I play with my friends where words get added x times to that list. Currently, I´m using the same three lines of code 5 times and I´d like to instead just call up a predefined funtion 5 times. is that possible? (I only translated the… Read More How would I define a function for this? [Noob question]
Advertisements Hi I’m new to Python and I’m wondering why I was only able to put numbers and not actual names in this code. When I added name I ran into a SyntaxError. my_age = 27 half_my_age = 13 greeting = Hi name = Max greeting_with_name = Hi + Max print("my_age + half_my_age + greeting… Read More Why can I only insert a number and not a name?