Img of Problem — TASK: Separate the location field into two columns for latitude and longitude Location Field: (37.709725805163, -122.413623946206) — QUERY: SELECT location, TRIM(leading ‘(‘ FROM LEFT(location, POSITION(‘,’ IN location) – 1)) AS latitude, TRIM(trailing ‘)’ FROM RIGHT(location, LENGTH(location) – POSITION(‘,’ IN location) ) ) AS longitude FROM tutorial.sf_crime_incidents_2014_01 — PROBLEM: I want to… Read More Hi! Can someone please help me figure out why and how this query works? I can't understand the logic behind it. Thanks so much

SELECT BTRIM(‘"enterprise"’, ‘"’) > Output = enterprise I need to use BTRIM function to trim the double quotes like above, with jsonb_array_elements function. I have a query like below, SELECT jsonb_array_elements(json_column->’Fields’)->’field_name’ as "column" FROM table_a Which returns column "Value1" "Value2" "Value3" I need the output without double quotes like below. column Value1 Value2 Value3 >Solution… Read More Use Trim Function With jsonb_array_elements in PostgreS

I need a function that takes a list of numbers as the input and an optional integer keyword argument trim (that takes on values of 0 or larger). I want to remove the largest and smallest numbers from the list and Return the mean of the numbers left. However, I keep getting errors. I am… Read More Function to trim a list and calculate mean of remaining numbers

For this document: { "_id" : 3, "name" : " Shyam Lingam " } Expected: while retrieving _id = 3 then result should come like below: { "_id" : 3, "name" : "Shyam Lingam" } I tried this: db.collection.find({_id:3},{name:{$trim:{input:"$name"}}}) { "_id" : 3, "name" : "Shyam Lingam" } but still whitespace between Shyam and Lingam… Read More remove whitespace which are in between String in Mongodb

This is my data looks like my_list = [(‘Australia’,), (‘Europe’,)] I need to remove the comma "," after every element. new_list = [(‘Australia’), (‘Europe’)] I can achieve this using a loop and extracting one element at a time and replacing it. Is there a better way to achieve the same. Thank you >Solution : That… Read More Python: how to form the correct list

hashCode = 0x39505b04f1c2e5c03ea3 I want to see only 10 characters, How ? >Solution : If you want to see the first 10 characters: hashCode = ‘0x39505b04f1c2e5c03ea3’ print(hashCode[:10]) outputs: ‘0x39505b04’ If you want to instead see the last 10 characters: hashCode = ‘0x39505b04f1c2e5c03ea3’ print(hashCode[10:]) outputs: ‘f1c2e5c03ea3’

$string = "this is a string biggest string bigger than the string1 string"; $random_position = rand(0, strlen($string) – 1); $chars = "👴🏿👩🏿‍💻🧑🏿‍🚀🧚🏿🤦🏿‍♀️👬🏿🚣🏿‍♂️✡️♈️🈯️🆗👩🏾‍❤️‍👩🏼🧑🏼‍❤️‍🧑🏻"; $random_char = $chars[rand(0, strlen($chars) – 1)]; $newString = substr($string, 0, $random_position) . $random_char . substr($string, $random_position); echo $newString; this is my code and I want to add these symbols in my string at… Read More I want to add symbol at random place in string how can i do that?