Is it possible to get only part of a cell‘s (SQL) data?
2024.11.29 15:47 nirbyschreibt Is it possible to get only part of a cell‘s (SQL) data?
I hope I use the correct terms for my question because SQL isn’t my field anyway.
My task is as follows: we have a database with client names and addresses and need once a week an excerpt of this data filtered by certain conditions. For reasons in the name cells are sometimes more than one name and those names are separated by comma. For example: - first name: Claudia, John - last name: Miller, Smith
Those refer to Claudia Miller and John Smith.
I need to put this data into tab separated text file. We have a Visual Basic program for this that needs to be replaced by a Python script.
My question is: Can Python group the names for me? It will need to read information in a single cell from comma to comma. The information is stored in this way in the database. Can’t change this. I find many ways how to handle SQL excerpts in csv or Excel files, but all will use the whole data of a single cell.
submitted by nirbyschreibt to learnpython [link] [comments]
2024.11.29 15:47 Reasonable_Salary_56 Mi monitor ahora es 4:3 y no 16:9
 | Cómo dice el título, me compré una gráfica nueva y está detecta mi monitor como si fuera 4:3 y no pude encontrar ninguna solución. Otras resoluciones si pueden llegar a cubrir todo el espacio en la pantalla pero si pongo la resolución máxima de mi monitor que es 1680x1050 no me la acepta y me deja la pantalla cuadrada con barras negras a los costados. Mi monitor es medio viejo y usa vga (para conectarlo a la gráfica estoy usando un adaptador de display port) que con mi placa anterior funcionaba correctamente. submitted by Reasonable_Salary_56 to ArgenGaming [link] [comments] |
2024.11.29 15:47 Yoyoyoshi1234 Our new friend doesn’t seem to be a slouch, at least. I like that
 | submitted by Yoyoyoshi1234 to PokeMedia [link] [comments] |
2024.11.29 15:47 shypetalz Am I worthy enough to be your cumtoy?
 | submitted by shypetalz to Daddys_Broken_toys [link] [comments] |
2024.11.29 15:47 Vlyer [GPU] XFX Speedster MERC310 AMD Radeon RX 7900XTX ($1,330 - $1,015 = $315) [Amazon]
submitted by Vlyer to bapcsalescanada [link] [comments]
2024.11.29 15:47 skpetesk MENSA denne nech neosprostieme
 | Tak uz aspon viem ze clenom nebudem submitted by skpetesk to Slovakia [link] [comments] |
2024.11.29 15:47 paulomehabu Vocês que assistem de tudo, o que costuma acontecer depois?
 | submitted by paulomehabu to porramauricio [link] [comments] |
2024.11.29 15:47 Deuce17 Cavaliers Media Coverage Criticism
In case you haven't noticed, the Cavaliers are the best team in the NBA right now. You wouldn't know that by listening to the mainstream media though, as the Lakers and Celtics still dominate the NBA media coverage landscape (as always).
And in my professional opinion, the major networks do a bad job at telling compelling stories that resonate with passionate local fan bases (part of why Reddit exists tbh). We're living in the era of hot takes and clickbait. Disclaimer: I run a podcast network that covers the NBA as well as other sports.
So my question is "If you were sitting in front of the microphone/camera, what would YOU want to add to the conversation"? Assuming everyone in here is a die hard Cavs fan, I want to know if any of y'all have stories worth sharing with a wider audience. Would you be down to be interviewed on a podcast episode?
I'd love to hear more directly from the people that care most!
submitted by Deuce17 to clevelandcavs [link] [comments]
2024.11.29 15:47 ImmortalBoy_ Tier list of the songs I’ve listened to.
 | Tell me, is this a good list? submitted by ImmortalBoy_ to BendyAndTheInkMachine [link] [comments] |
2024.11.29 15:47 Psych_Eval_ Selling 2 tickets for Detroit 12/18 at The Majestic at cost plus fees, $97.08
Message me if you're interested. I can't make it anymore 💔
Tickets purchased for $36 with fees on ticketweb, delivery via email. Zelle, Venmo, cash app is good.
submitted by Psych_Eval_ to thebloodbrothers [link] [comments]
2024.11.29 15:47 Ok_Exercise_3059 not the rice cracker base 😭 i genuinely don’t mind her content but some of it recently is insane
 | submitted by Ok_Exercise_3059 to EDRecoverySnark [link] [comments] |
2024.11.29 15:47 porvis [NM] 40489 Mr. and Mrs. Claus’ Living Room - 172 Spots at $2/ea
Item name: Mr. and Mrs. Claus' Living Room (40489)
Set Price / Justification: $322 (BE, 11/11/24) + $0 tax + $22 shipping
Shipping: UPS Ground 3lbs - 12x17x4 from 27703 to 98038, declared value of $350 = $22
Price: $344
Call spots? yes
Spot limit per person? no
Duration of spot limit? n/a
Location(Country): USA
Will ship international? No. AK/HI - buyer pays extra shipping
Timestamp/pics: https://imgur.com/a/nxj5pua
Description: Unreleased Christmas GWP!
Payment required w/in 15 minutes of raffle filling. 10 minutes for drama.
DO NOT ADD A COMMENT TO YOUR PAYMENT; IF YOU HAVE ANY QUESTIONS, PLEASE MESSAGE ME BEFORE PAYING;
submitted by porvis to lego_raffles [link] [comments]
2024.11.29 15:47 julie_nighthawk Black Friday 🖤
 | submitted by julie_nighthawk to crossdressing [link] [comments] |
2024.11.29 15:47 Crazy-Promise9230 Four years ago, I owned a crafted AK-47 Black Laminate with 4x Penta Holo Katowice 2015 stickers, but unfortunately, I sold it. Recently, while going through some old clips, I stumbled upon footage of it and managed to track down the current owner. Now, I’m thrilled to say I have it back!
 | submitted by Crazy-Promise9230 to ohnePixel [link] [comments] |
2024.11.29 15:47 SometimesNibbi all of the makeup i own as a 21yo who never hits pan on her stuff
 | submitted by SometimesNibbi to indianbeautyhauls [link] [comments] |
2024.11.29 15:47 movieperson2022 Embarassment of riches good fortune opinion request
Yesterday, I went bonkers and entered every single lottery. I am only in New York today and tomorrow, so I just wanted the experience. By some miracle, I won three tickets. Happy Thanksgiving to me!
One was for matinee and two were for evening. So, of course, I took the matinee and did my research to do a best guess for the evening show. I am sad I couldn’t go to all three, but I made my pick. I’m not going to say which one was the matinee for the sake of my question, but I’m just curious as a thought experiment what combination this community would have picked.
If you guys had to choose any two of these three shows, which would you have done?
(Alphabetically)
Left on Tenth Teeth Water for Elephants
I know only one of these is considered a “bigger” show, but I’m just curious what others would have done if they got to see of these. Just for fun (and hopefully validation haha). Regardless, I’m super excited for my big Broadway day!
submitted by movieperson2022 to Broadway [link] [comments]
2024.11.29 15:47 Playful_Sweetie check
submitted by Playful_Sweetie to WhatIsMyCQS [link] [comments]
2024.11.29 15:47 Khulapdang Looking for active club
 | submitted by Khulapdang to eatventureofficial [link] [comments] |
2024.11.29 15:47 Psychological_Reason Gavekort til god hårkur i Aarhus?
Hej alle!
Som titlen afslører leder jeg efter et sted i Aarhus at give min kæreste et gavekort til en hårkur + klip af spidser.
Er der nogen af jer der kender et godt sted at få gjort dette? Black Friday rabatter skader jo heller aldrig :D
submitted by Psychological_Reason to Aarhus [link] [comments]
2024.11.29 15:47 olliewolly257 Voicemeeter driver preventing 24H2 update
 | https://preview.redd.it/rksczjyr2v3e1.png?width=735&format=png&auto=webp&s=4af306594ef15c8cfc002a991c402b3a0dac9b23 How do i fix this? im trying to update to windows 11 24H2 and its telling me this. ive checked through all my installed apps and drivers and i cant find anything to do with "voicemeeter". (i also checked to make sure i dont have vb cable installed either before anyone asks) submitted by olliewolly257 to WindowsHelp [link] [comments] |
2024.11.29 15:47 AntoniumIII [Monsters' Convent 1# - Orbis de Luxuria]
Sister Pórpura, the Prioress, tryies to check out if the orfanage boy are having thoughts they shouldn't.
submitted by AntoniumIII to comics [link] [comments]
2024.11.29 15:47 EDarkness1 Ekko & Jinx - (marsipanart @marsipanart (Tumblr) [Repost])
![Ekko & Jinx - (marsipanart @marsipanart (Tumblr) [Repost])](https://preview.redd.it/ylga4gd03v3e1.jpeg?width=640&crop=smart&auto=webp&s=604409210d7cffe6a85815ca19a23d2eb5f26d02 "Ekko & Jinx - (marsipanart @marsipanart (Tumblr) [Repost])") | submitted by EDarkness1 to TimeBomb [link] [comments] |
2024.11.29 15:47 Big_Contract_9932 Kendrick Lamar Fan Page (@kendricklamarzz) on Threads
 | submitted by Big_Contract_9932 to truthislit [link] [comments] |
2024.11.29 15:47 Plus_West_4939 (Battle of the Minis) ChatGPT4-O-Mini VS Mistral Nemo: Brainstorming battle from a story seed
I’ve been developing an AI tool for creative writers and decided to test the creative capabilities of ChatGPT4-Omni-Mini and Mistral Nemo using the same story seed as a benchmark. This is both an evaluation of their storytelling abilities and a showcase of how the tool works.
This is the prompt with the seed of the story. From this seed, we get different outlines from ChatGPT4-Omni and Mistral Large:
Using the The Three-Act Structure writing technique adapted for romance develop an outline of 1000 words for a romantic story with a bittersweet ending:
The protagonists are a young extraordinary talent teenager inventor called Sonia and a teenager boy called Alex who is smart and a talented athlete. Sonia has invented a Time Machine that allows to freeze the time for 2 person for an undefined amount of time, but every time she uses there is a substantial time to cool down in order to use it again. The initial incident is a big meteorite that is going to impact Earth erasing all life in the planet. Sonia uses the machine in order to save herself and Alex, but Sonia tells that she doesn’t know why Alex was saved by the Time Machine. They start to work together looking for a way to save the planet. 10 after the incident Alex discovers the truth that Sonia had really chosen him on purpose. Alex decides to leave her and for 20 years they follow separate paths. Then Alex finds out a possibility to save the planet and goes back with Sonia to share is findings. Sonia confirms his findings but tells him that to save everyone else they will have to die. They accept their fate and expend the next 20 years together until they run the plan, saving the planet and dying in the process.
With the outlines, we can create the full story with the cheapext LLM models form OpenAI and Mistral.
In the links with the final result (link to the final text generated, link to the prompt history) so you can test it yourself. This is specially usefull for people who want to become professional prompt engineers. In order to fully understand the prompts you need some basic knowledge of JSON and XML formats:
- "Timeless Sacrifice" outlined by ChatGPT4-Omni and text generated by ChatGPT4-Omni-Mini.pdf)
- Cost $0.02
- Time: 2 hours
- "Timeless Sacrifice" outlined by Mistral Large and text generated by Mistral-Nemo..pdf)
- Cost: $0.025
- Time: 2 hours
submitted by Plus_West_4939 to WritingWithAI [link] [comments]
2024.11.29 15:47 ScientistContent1129 Back in 2000, Kevin Hines jumped off the golden gate bridge due mental illnesses. He miraculous survived because a sea lion was bumping him up and kept his head above water. Now he is a suicide prevention speaker.
 | submitted by ScientistContent1129 to Damnthatsinteresting [link] [comments] |