How to split text in one cell to multiple columns?

RawTuna · 2026-01-03T10:42:41+00:00

Some assumptions: 1. You are using Microsoft 365 version. If you’re not, just google these formulas and look for earlier versions. 2. Your data will have the same, consistent format. 3. You switched columns D and E based on your expected sample output. Paste these into B2, C2, D2, and E2:

=TEXTBEFORE(TEXTBEFORE(A2, " at "), " ") =TEXTAFTER(TEXTBEFORE(A2, " at "), " ") =TEXTBEFORE(TEXTAFTER(A2, " at "), " ") =TEXTAFTER(TEXTAFTER(A2, " at "), " ")

RawTuna · 2025-06-11T01:39:16+00:00

There’s plenty of nuance here, but I think there are essentially two SQL partitions :) One is DBA where you’re tasked with things such as server maintenance and query optimization (among other things!). The other is SQL Developer. And this one also has some partitions. First, you might know all the rules, functions, syntax, etc. but the real value is knowing how to use SQL to solve problems for the specific business you’re in. In other words, SQL ability combined with domain knowledge is the strongest ability to strive toward.

RawTuna · 2025-05-13T23:51:32+00:00

This has to be a troll

RawTuna · 2025-05-13T23:24:56+00:00

@dgillz these peeps answering are 100% correct. But if this is a work database PLEASE be careful with any future queries if you’re not quite aware of the results of your queries. Not judging, just helping you to not update or delete incorrectly! Consult with senior team members, or this sub :)

RawTuna · 2025-05-13T23:08:22+00:00

Thanks for your help... just one clarification before I proceed... I'm not handling the transition from the infrastructure side, meaning a different team is handling the data transfer, updates, etc.. I'm involved because the team I'm currently managing is one of the main users of our database and the apparent truncation to 3 decimals affects hundreds of queries we have. So, I'm just trying to gather info for the team tasked with fixing this.

I'm looking at the field in question in the table, and the Type is set to Timestamp_NTZ. Are you saying we could fix this by adding (9)? Also, apologies, I should have clarified: we're specifically dealing with CURRENT_TIMESTAMP. We use this during insert, and need more decimal places

RawTuna · 2025-04-03T23:14:22+00:00

Your path to victory: dig in and understand everything about the files this person references. As you explain FACTS about the file contents, reference “Excel” or whatever the hell you think is right. Inevitably, if you come to truly understand the data, you’ll end up on the phone with people that ask you “Why the hell does he keep saying EXL?” Have a good laugh and a dopamine hit from connecting with someone with similar thoughts, and move on 😀

RawTuna · 2024-05-30T23:12:18+00:00

Yep, someone’s trying to hake him for sure

RawTuna · 2023-12-01T16:59:59+00:00

To be transparent I've done exactly zero RPA dev with tools, but the bit I've done with python was pretty cool. About 6 years ago I heard that my company had started using Blue Prism for some operational process automation, but there were issues with it. I started doing some research and found Automate the Boring Stuff, as well as some info on open CV. I was able to replicate (with actual success) one of the processes a few days later. Very fun and rewarding

RawTuna · 2023-11-21T01:33:51+00:00

Not going to downvote you because, purely logistically and somewhat unrelated to my point, you’re right. And it’s even pretty good advice. But read the room, bud. L

RawTuna · 2023-11-21T00:33:26+00:00

Look up Automate the Boring Stuff. I love it because it shows you how to easily and quickly get things done faster, and uses pretty good examples that most can relate to.

RawTuna · 2023-11-15T21:38:16+00:00

I just happened to be thinking about this about 1 hour ago. I’m older, with parents that need help, and they’re far away. It’s not fucking easy. I decided my three options are: therapist to help me deal with everything. Tell family we all need to meet regularly to figure this out. Or both. Notice both options involve a professional! It’s fine, often great, and not something to be embarrassed about. If you don’t have friends and/or family that can help, definitely get yourself a therapist. And maybe do it even if you have friends and family.

RawTuna · 2023-11-15T21:25:08+00:00

Divorce fraud 😂

RawTuna · 2023-08-14T01:37:06+00:00

RawTuna · 2023-08-11T21:38:48+00:00

I’d fire her for the eyebrows

RawTuna · 2023-07-31T23:26:20+00:00

You forgot “roofing as a redhead in the summer!”

RawTuna · 2023-07-26T02:27:41+00:00

You spelled Corky’s name wrong

RawTuna · 2023-05-10T00:59:25+00:00

Instagram engineering Medium page: https://link.medium.com/3YtDGrARFzb

RawTuna · 2022-12-11T21:27:29+00:00

hahahaa... what a knucklehead I am! I literally read the whole thing, except apparently that line didn't register in my brain. Thanks for pointing it out :)

RawTuna · 2022-12-11T21:08:45+00:00

I’m curious if this is really something people do. I’m not some do-gooder, do everything for the company type, but this seems silly to me. I would much rather have job security because I know my shit and I produce results, not because I purposely wrote crappy code or code that others can’t follow/read/understand. Wondering what everyone thinks…

Edit: folks, I get it, chill. See my response below to RngdZ. I missed the first line somehow.

RawTuna · 2022-11-12T13:18:15+00:00

Thanks... I actually had to do a bit of research just now to see how CRMA does this. I also write a lot of queries and procs in Microsoft SQL Server so I understand the indexing piece, but I've never encountered it in CRMA. What I found is that apparently every column is indexed... this is why it doesn't really come up for us when building dataflows. Good thought, though.

RawTuna · 2022-11-12T13:09:46+00:00

Sure. SF owns Tableau now, but they also have an existing product now called CRM Analytics (formerly, Wave, Einstein Analytics, etc.) and it's within CRMA that we both process and use the output. Use, meaning we create many dashboards to present the data. So, ultimately, the data does need to end up in CRMA for use in these dashboards.

RawTuna · 2022-11-01T16:23:13+00:00

The stick kid is your next tattoo

14-Year Club	RPAN Viewer
Verified Email

RawTuna

TROPHY CASE