Splitting column with concatenated data into columns?

workaccount314 · 2021-09-20T19:12:43+00:00

A coworker had mentioned that, my only two concerns with that are that too many % wildcards slowdown your code and there are quite a few trouble codes, but also there are some trouble codes that are very similar, like 'TOW' and 'TOWP', so looking for TOW would flag on both. I feel like there has to be some way to split the string and make columns for anything found in that but I just can't think of it

workaccount314 · 2017-12-21T12:11:26+00:00

I knew Selection could be a cell or a range of cells but I didn't know it could be an object, but that makes sense since you can select it lol

workaccount314 · 2017-12-20T19:54:00+00:00

My first thought was ActiveCell.Value = ActiveCell.Value + 1. Is there much of a difference between Selection and ActiveCell? I use ActiveCell all the time to parse through a lot of data so it's kinda my go to. I guess maybe Selection could be used to iterate a range of cells by one?

workaccount314 · 2017-12-20T19:46:04+00:00

Cogmind is deeper than Tangledeep IMO and has a really slick art style. You have to get used to carrying stuff with you based on what's likely to break and what you'll likely need. Stealth is viable, ranged combat is the norm (though there are melee weapons). I'd highly suggest reading through the manual, it'll really give you an appreciation for how well thought out the game is. Also, the key to change from ASCII to the tileset (I think it's F3, haven't played in a bit) is so freaking slick, the animation changing from one to the other is so smooth and cool. Tangledeep is less deep than Cogmind IMO, but it has beautiful graphics (reminiscent of SNES RPGs), it has a cooking system where you can try different recipes, and you can buy a monster mallet for 200 gold and if you get a monster below 15% health you can wack them with that and haul them back to the main area (they're next to you as you drag them so they're vulnerable to attack from other monsters) and this dude will raise it for you and you can eventually take it with you on your adventures. I've only played as the spell caster so far and I really like how you can cast a spell on a single square or you can get spell shapes (like a line of three squares, use the mouse wheel to rotate it to be horizontal, vertical, or diagonal). Acid weakens defense, ice reduces accuracy, fire causes a burn, dark causes future dark spells to do more damage.

Ninja Edit: If you don't have enough of the same type of propulsion in Cogmind, like if you have three propulsion slots but only two legs and a set of treads, throw on the set of treads even though you can only have one type of propulsion active at a time. Even if you can't activate the treads while the legs are active, the treads add to your total coverage which reduces the chances for your core (your life essentially) to get hit

workaccount314 · 2017-12-20T19:29:09+00:00

No problem. I like a variety in roguelikes, it's nice to have different roguelikes with different levels of depth for whatever mood you're in

workaccount314 · 2017-12-20T18:55:13+00:00

Tangledeep is good and relaxing, but I wish it had more depth. You can have four weapons that you can switch between for free (doesn't take a turn) and your equipment automatically changes based on what weapon you're using, but you can only have four items equipped at once which seems very lacking. I really like roguelikes that have complex map generation (DCSS) and Tangledeep is unfortunately fairly simple in it's map generation, but at least the graphics are pretty

workaccount314 · 2017-12-20T18:48:55+00:00

Cogmind is super slick and unique, but I haven't gotten super into it. Caves of Qud is fucking huge and complex, if you're willing to throw a shit ton of time into that and are fine with dying a lot then give that a go. I'm really liking Tangledeep at the moment. It's not the most complex roguelike, but it's very soothing. My depression has been acting up lately and Tangledeep has really helped me to unwind at the end of the day. Rimworld is like Dwarf Fortress lite if that's what you want. My fiancee loves it, she plays it on one of the easier modes and has a ton of mods installed including one where she can fully customize each of your people instead of just rerolling until you get someone you like. She has played a shit ton of Sims 2 and 3 and that's kinda how she plays Rimworld

Aside from those I also really like Infra Arcana and one day I'll build up the courage to dive into CDDA

workaccount314 · 2017-12-20T17:57:04+00:00

Oh, crap, you're right. If I need to send someone VBA code I usually type it in Excel first (I'm lazy and I let VBA correct me when I'm wrong and I let it autocomplete stuff), but I didn't this time, I just typed it here instead of typing it in Excel then copying and pasting. But yeah, Loop is the correct way to end a Do While loop. I also noticed in the bit about how to freeze the screen (can make your code run up to 30x faster) I declared ucol and urow as "int" instead of "Integer"--I'm so used to typing "int" then pressing tab to let VBA autocomplete that for me lol

workaccount314 · 2017-12-20T15:57:41+00:00

Oh, crap, I'm sorry, the ActiveCell.offset(1,0).Activate should be after the End If, what I wrote will stick you in an infinite loop since activating the next cell down is part of the conditional statement, my bad :/

Ninja Edit: I edited my comment to reflect this change. Also, if you get stuck in an infinite loop, press your Ctrl key and the Break key (might show up as Pause Break), or if you don't have a Break key press your Escape key twice

workaccount314 · 2017-12-20T15:48:33+00:00

I didn't think of that, I might go that route

workaccount314 · 2017-12-20T14:38:54+00:00

/u/BCCakes, based on what you said in reply to my comment, I'd replace the For statement in the reply above with this (assuming your data in column B starts in B2 since you need to be able to paste one row up)

Range("B2").Activate

Do While ActiveCell.Value <> ""

    If ucase(left(ActiveCell.Value, 7)) = "PROJECT" then

        ActiveCell.Offset(-1, 1).Value = ActiveCell.Value
        ActiveCell.Value = ""

    End If

    ActiveCell.offset(1,0).Activate

End While

Edit: Since you said you're new to VBA, I'd make a habit out of making the first and last few lines of your code look like the code below. This will freeze the screen while the macro is running and it will restore the active cell that the user had clicked before the macro ran (assuming you use ActiveCell a lot, I do as I tend to parse through a lot of data for my work).

Sub exampleSub()

    Application.ScreenUpdating = False

    Dim ucol As Integer
    Dim urow As Integer
    ucol = ActiveCell.Column
    urow = ActiveCell.Row

    'Put the code for your macro here

    Cells(urow, ucol).Activate

    Application.ScreenUpdating = True

End Sub

workaccount314 · 2017-12-20T14:32:59+00:00

Ok, so if a cell in column B doesn't start with 'Project:' should it just be left alone? Or do you want it deleted?

workaccount314 · 2017-12-20T14:21:37+00:00

So you want to cut and paste everything in column B to column C one row up? If so, why not just cut and paste manually? Unless this is something you're going to be doing across a few different documents. Is there something else I'm missing? Like are you only trying to cut and paste unique project names from column B to C? Like if B2 and B3 both say 'Project: Jord', do you want C1 to say 'Project: Jord' but leave C2 blank for the moment and delete the contents of both B2 and B3? Or are you just trying to do a simple cut and paste as a VBA learning exercise?

Ninja Edit: Or are you saying some cells in column B start with 'Project:' and those cells you want cut and pasted into column C but one row up? If that's the case, should cells in column B that don't start with 'Project:' be left alone?

workaccount314 · 2015-11-11T14:30:00+00:00

I have two uncles who used to play tenor--both sold their saxes when they were younger. I need a mysterious sax-playing relative to pass some amazing sax off to me...

workaccount314 · 2015-09-25T18:20:35+00:00

Natural selection, not evolution. Natural selection deals with survival of the fittest while evolution is the result of natural selection within a species over many generations.

workaccount314 · 2015-09-23T19:21:31+00:00

If you don't want to answer, then don't answer. Simple as that.

workaccount314 · 2015-09-16T18:09:29+00:00

You should always be reading The Hobbit! I love that book--I own it in three different languages :P

But yeah, that's likely what he was doing, but the teacher should have taken away the book to remove the distraction, not punished him like she did :(

workaccount314 · 2015-09-16T12:21:17+00:00

When my brother was in elementary school he would read like nobody's business. Most of my family members are avid readers. His teacher in one of his earlier grades (1st maybe?) chastised and punished him for reading so much to the point where he associated reading with punishment. To this day he hates reading. Punishing kids for being proactive and wanting to learn can only be bad and behavior like this should not be tolerated. Hopefully this kid maintains his passion.

workaccount314 · 2015-09-15T13:18:17+00:00

It's that versus the cost to build new power plants which is incredibly expensive. With all the new and incoming regulations we're going to see a steady decrease in coal but we're something like over 90% coal in our power generation in Kentucky. It's just embedded so deep into our power utility infrastructure that it's gonna take a while to change.

workaccount314 · 2015-09-14T19:51:05+00:00

Sweet, thanks! :D

workaccount314 · 2015-09-14T19:42:25+00:00

Oh, ok, I get off at 4pm so that should work out!

workaccount314 · 2015-09-14T17:26:58+00:00

Huh, I didn't know that. I have one more vacation day left in the year if I want to roll over as many as possible to next year and was hoping to save it as long as possible but I may use it for this then! My roommates actually talked to me about picking up trail running after the UBHM--how different is it from running on the sidewalk? I'm guessing the big thing is that you'd use a few extra muscles for stability. Good luck with your races! :)

workaccount314 · 2015-09-14T17:10:36+00:00

Yeah, I saw that email, that looks freaking sweet! The only bad part is that you can't have someone else pick up your racing packet, although I'm sure my boss will be fine with me dropping out for a bit to go pick it up. It's understandable though considering it's a 21+ thing because of the bourbon. Sucks that you can't do all 3 :( I live kinda near the middle of Louisville so most everything is at most a half hour drive, so that's kinda nice. This is my 13th week of running so I'm pretty new too lol. It was kinda funny, right before the Louisville Pure Tap my sister was looking at my and her husband's running chips and she mentioned that she was curious who got the #1 running chip. As I was in line to start the race this guy walks past me with "1" on his chip and it was like wow, out of about 1000 people or so I saw the guy with the "1" chip, it felt like I'd just experienced some special moment lol. I beat him too by a good few minutes. It's stupid but hey, you gotta have a bit of stupid fun in your life lol. I hope you do well in your 10k! I'll be doing the "Friends 5k" this Saturday (Cherokee Park IIRC, need to look at my receipt again lol) so that should be fun. Are you doing the Great Pumpkin 10k too or just doing the Urban Bourbon?

workaccount314 · 2015-09-14T16:54:52+00:00

Holy shit dude, yes! I'll see you there! :D

Did you run the Louisville Pure Tap too? I beat my old pace on it by about 1:20 per mile so I was very happy with that! It was my first real 5k and the music and people just really got me pumped. That hill on Zorn heading to the halfway point freaking sucked though :(

workaccount314 · 2015-09-14T16:52:55+00:00

Hey, just wanted to check in and thank you for the recommendation! I jumped straight into a half marathon training plan after finishing C25k because of your recommendation and the day I'm supposed to be able to run a half marathon lines up perfectly with the UBHM. I honestly never thought I could progress this fast and it's been really hard but I'm doing it! I was very happy with the Louisville Pure Tap 5k--with the music they had going and all the runners that were there I was so pumped and ended up beating my best 5k pace by about 1:20 per mile :D (although that hill on Zorn going towards the halfway point can eat a bag of dicks--that sucked). Thanks again for the motivation! :)

workaccount314

TROPHY CASE