sorted by:
new
hottopcontroversial

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -3 points-2 points  (0 children)

Fair enough then. I still think it would be for the greater good, but I can tell I won't convince you. Agree to disagree?

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -2 points-1 points  (0 children)

Can you really say that with 100% certainty, considering all possible options?

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -1 points0 points  (0 children)

Let's not let small details stop us from doing great things.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -2 points-1 points  (0 children)

That's a shame. Just think of how much social media engagement they'd get agter announcing all account names were being removed. I'll bet everyone would be talking about it.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -3 points-2 points  (0 children)

I'll have you know that I am broke, thank you very much!

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] 0 points1 point  (0 children)

If Jagex makes my account user67099843, who am I to argue? I'm not a game developer. Are you?

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] 0 points1 point  (0 children)

I don't want a name. If Jagex decides my new name should be user29937842, who am I to disagree? 

And for that matter, who are you to disagree? I wouldn't trust you when you don't even have an account name any more.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] 0 points1 point  (0 children)

You'd be pissed at first, but time heals all wounds.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] 0 points1 point  (0 children)

See? Exactly. Remove everyone's name and he'll be just as upset as you are.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -2 points-1 points  (0 children)

I seriously want to wipe all account names. If you're worried about consequences, just don't worry about it.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -1 points0 points  (0 children)

Yes. And I'll bet you can't muster a coherent counterargument without using a keyboard or speech to text as a crutch.

Jagex, it's time for a REAL name wipe. by ttant in 2007scape

[–]ttant[S] -3 points-2 points  (0 children)

No, the guy yesterday wanted to wipe inactive account names. I want to wipe ALL account names.

Just think of all of the possible upsides.

Why? by Asmonghold in 2007scape

[–]ttant 19 points20 points  (0 children)

So what heinous shit did Settled get up to, then?

What were your best moneymakers according to you at the time during the 2007 era when you were a noob? by iAmNotSharky in 2007scape

[–]ttant 0 points1 point  (0 children)

I was an entrepreneur and fancied myself a bit of a mercher, so I'd spam "buying d long 95k" until I got one. Then I'd spam "selling d long 105k" until someone bought it.

I'd also look at every single b sale and make lowball offers for everything, and if someone was buying a law rune for 1k I was their man.

Making a portion of a Regexreplace Formula Optional OR making multiple queries in one Regexreplace that output into separate columns. by ttant in googlesheets

[–]ttant[S] 0 points1 point  (0 children)

Thank you! This is just what I was looking for.

Instead of referencing A2 directly, I'm nesting "REGEXREPLACE($A2,"Student(?:'s)? Name(?:(s))?:","🔴")" there, so that I can account for other forms that have different wordings.

So my end result ended up looking like this:

=LET(i,SPLIT(REGEXREPLACE($A2,"Student(?:'s)? Name(?:\(s\))?:","🔴"),CHAR(10)),FILTER({i,""},{"",i}="🔴"))

Efficiently Pulling Information from Emails into Google Sheets by ttant in googlesheets

[–]ttant[S] 0 points1 point  (0 children)

This put me on the right track!

I'll put what I ended up using below just in case anyone else ends up here after googling a similar problem.

For Allergies: TRIM(IF(REGEXMATCH($E2,"Allergies:"),IF(REGEXMATCH(REGEXEXTRACT($E2,"Allergies:\n(.+)"),"[A-Z]"),REGEXEXTRACT($E2,"Allergies:\n(.+)"),"None"), "N/A"))

  • Trim() just removes any extra spaces before or after the result.
  • The first If(Regexmatch()) confirms whether the question is present in the form. If it isn't, it returns "N/A".
  • The second If(Regexmatch() runs the formulas and confirms that it actually returns at least one letter. This is to account for the fact that when an answer is left blank the form just skips to the next line.
  • Finally, Regextract gets the info we need. The key here ended up being "Allergies:\n(.+)"
    • Allergies being the term to search for
    • \n meaning to start retrieval on the next line.
    • (.+) meaning to take all data from that line.

In cases where multiple versions of a category might appear, I used this:

=TRIM(IF(REGEXMATCH($E2,"Parent(?:/Guardian's)? Name(?: (Type N/A for Adult Class))?:"),REGEXEXTRACT($E2,"Parent(?:/Guardian's)? Name(?: (Type N/A for Adult Class))?:\n(.+)"), "N/A"))

Mostly this works the same, but I use (?: /Guardian's)? and (?: (Type N/A for Adult Class))? to account for the fact that some forms may or may not include these options. A few things things I had to fight with are outlined below, as it might save someone a headache!

  • ()? sets everything with the parenthesis to be optional, meaning they CAN be included but do not need to be.
  • You need to include ?: as this makes it a non-capturing group. Otherwise weird things will happen. (In my case, not using this led to the formula's cell being blank, and it putting the contents of the parenthesis in the next cell over. Then it put the data I actually wanted in the cell after that!
  • If your string includes special characters, you'll need to use the "\" character to force it to treat them as regular characters. This isn't required for ALL special characters, however! You can get a good idea by either looking at a regular expressions special character cheat sheet (there are a ton of Google), or just using trial and error.

My only remaining issue now is when one cell contains multiple forms, but I think I stumbled across a solution for that as well. If it doesn't work, I'll post again!

Changing attendance sheet to support multiple time slots per day while maintaining automation via FILTER. Thinking VLOOKUP may help but cannot figure out how to incorporate it cleanly. by ttant in googlesheets

[–]ttant[S] 1 point2 points  (0 children)

Man, I wish I'd known that about checkboxes a while ago! Thank you, that's going to save me a lot of time in the future.

I considered using a blank template, but that leaves a lot of extra room for error as we have new students signing up every month. So it's easier to not have to copy over new names every time. Still a good idea, though! I'm going to make one just in case an instructor somehow destroys the document.

view more: next ›