Data scraping advice for addresses

If you ever need to parse thousands of text addresses from strings into city, state, zip code, etc., here’s my advice…parse the text from right to left. Start by trimming the first five characters from the right and test them for IsNumber (sometimes it will be part of a county name, a typo, or an oddball zip code from another country), then trim the white spaces and do likewise for the state, and so on.

(It took me two days doing this the wrong way so I figured it would be worth mentioning.)

Use this formula too: https://stackoverflow.com/questions/350264/how-can-i-perform-a-reverse-string-search-in-excel-without-using-vba

About Aeoli Pera

Maybe do this later?
This entry was posted in Uncategorized. Bookmark the permalink.

65 Responses to Data scraping advice for addresses

  1. Obadiah says:

    How many rival drug dealers did u pop

  2. Obadiah says:

    Implications of Dumbledore being gay:

    Hogwarts is a pedophile ring posing as a school that is in the business of recruiting, grooming, brainwashing and molesting children, particularly vulnerable children (Harry had no parents and lived in an abusive household. Voldemort was literally recruited straight from an orphanage by Dumbledore).

    Dumbledore is grooming Harry Potter into his successor (the chosen one)

    Hagrid is Dumbledore’s “bag man” and muscle, tasked with the field work of procuring children.

    The Marauder’s Map and the Invisibility Cloak are both faculty items/tools that have fallen into the students’ hands. The Map is literally a tracking device for everyone on the premises.

    Patronus = orgasm

    • Aeoli Pera says:

      “Sometimes a cigar is just a cigar.”

    • Obadiah says:

      Voldemort was Dumbledore’s previous successor but it didn’t work out. Peter Pettigrew is a student who systemically evaded molestation (hence he is a “slippery rat”) and went on to side with Voldemort (Hitler/Alt-Right)

    • Obadiah says:

      “The Wizarding World” itself is possibly entirely make-believe. Michael Jackson was a lifelong occupant of the “Wizarding World”

    • Obadiah says:

      Doesn’t Harry learn the patronus spell at around age 13/14 (male puberty)? To cast the patronus you think happy thoughts until you ejaculate a milky representation of your psycho-morphic resonance out of your wand. It is your “seed”

      • Obadiah says:

        The quaternality (zodiacism) that the students are sorted into indicates the occult/hermetic nature of the faculty’s true ideology (“Nicholas Flamel is an alchemist”). Merlin, himself a Slytherin, stands in for Enoch of Cain/Hermes Trismagistus. Or maybe Salazar Slytherin is Thoth.

        • Obadiah says:

          Cain’s kids/grandkids are the “legendary house founders”–the preeminent wizards of antiquity.

        • Aeoli Pera says:

          I just posted you a new rabbithole.

          • Obadiah says:

            The Time Turner distorts the metaphysics of human life–what sociopaths do according to venkat. The entirety of Hogwarts is a grand example of “reality creation”.

            • Aeoli Pera says:

              Alternatively, it’s Eternal High School for very special indigo children.

            • Obadiah says:

              It’s probably both m8

            • Obadiah says:

              It’s value-conditioning for Edenic-expressing humans.

            • Obadiah says:

              Dumby doesn’t even have to be a pedo–just predatory/malevolent

            • Aeoli Pera says:

              >Itā€™s value-conditioning for Edenic-expressing humans.

              We don’t typically use that term to describe cro magnon whites or frizzy haired mulattos, who quite clearly feel emotional attachment to these stories.

            • Obadiah says:

              The kids are a mixture of Edenic types and cro-mags/sapes which is why their individual experiences differ vastly (Harry, due to his Genetic pedigree, is immediately groomed and mentored by Dumby and this continues until he is gassed by wizard Hitler).

              I knew a snake melon girl who basically had a religious reverence for HP.

              It’s value-shaping stuff for all the kids

            • Aeoli Pera says:

              >wizard Hitler

              Hereafter referred to as Jordan NEETerson.

  3. Obadiah says:

    Dumbledore: Arch-melon/Cain

    Snape: snake melon (hooked nose). Arch-deceiver (triple agent for Dumbledore) and potions-master (alchemist). Jealous of Harry

    Weasley family: economically-vulnerable/clueless neanderthals.

    The part in book 6 where dumby and Harry have to get the locket horcrux shows all the murdered people/victims from Cain’s bloodline trying to exact revenge (corpses emerging from the water/unconscious)

    • Obadiah says:

      The Basilisk, a giant, predatory phallus stealthily prowling the halls and secret passages of Hogwarts, represents the actual unconscious of the faculty. Tom Riddle’s diary documents Voldemort’s conditioning, molestation and eventual insurrection.

      • Obadiah says:

        Dumbledore is described as having Auburn or ginger hair (paracas skulls)

        The sape house elves gain freedom by gaining a piece of clothing.

    • Obadiah says:

      Snape, despite being Dumby’s top man, was ultimately not chosen to be the successor to the arch-wizard position. Hence his resent of Harry.

      Fawkes the Phoenix: ambient behelit myth

      • Obadiah says:

        Dumbledore’s patronus was a Phoenix!

        • Obadiah says:

          In other words, his patronus is a serpent of light, shedding it’s skin.

          The Obadiah/serpent-bearer character is of course Harry: he’s a parseltongue (innate skill at doubletalk/powertalk). Aka Genetic knowledge of good and evil.

  4. Obadiah says:

    >Sometimes a cigar is just a cigar

    More often though it’s Dumby’s withered old wand pumping toxins down your throat.

    • Aeoli Pera says:

      I regret ever trying to reason with a disagreeable person, ever in history.

      • Obadiah says:

        There’s a huge load of treasure here whether you agree or not tbh

        • Aeoli Pera says:

          I think you’re right on account of the archetypal High School being intrinsically predatory, and tending to circle the wagons around elite homosexual pedophilia.

        • Aeoli Pera says:

          That said, I don’t believe Harry Potter is really best explained by this analysis. I see this more as a reading of a potential resting state for the sort of social system described metaphorically. There will be some crossover too- for example, I think the patronus bit works regardless of whether Dumbledore is sodomizing the gifted children program.

          • Obadiah says:

            The pedo aspect may not have the most explanatory power (Dumby’s homosexuality was retroactively added as a “wink and a nod” after the books were done iirc)–but most of the other stuff I’ve associatively brainstormed about today certainly does

          • Obadiah says:

            So HP is basically set in the Eternal High School setting, but the story is centered on the subjective experience of the future melon God King and his close circle of Edenic friends and acquaintances, with the Cro-Mag subjective experience shifted into the background.

            • Obadiah says:

              For instance, Quidditch would be the archetypal “color coded team sport”, but in HP it mainly serves as a backdrop for two rival MM characters (Harry and Malfoy) to battle each other in.

            • Aeoli Pera says:

              Okay, I’ll buy that. Harry Potter as Griffith.

            • Obadiah says:

              The story of HP is basically Harry being groomed by Dumbledore to eliminate Voldemort, who is the Alt-Right/wizard Hitler, and the biggest threat to the Satanic order. Presumably, Dumbledore was similarly groomed to eliminate Grindelwald (wizard Hitler 1.0)?

            • Obadiah says:

              (Voldemort and Grindelwald are both “religious racists” and their revolutions are similarly threatening to the Cainite NWO–but ultimately misguided and doomed to failure due to Godlessness)

            • Obadiah says:

              >Harry Potter as Griffith

              Not specifically–Harry’s patronus would be a falcon if that were the case. Instead it’s a male unicorn* (identified as a “stag” in the story, which is probably a detail Satan deliberately distorted when he wrote HP).

              *Ref My Little Pony

            • Obadiah says:

              But yeah the basic general idea of “melon adolescent groomed to accomplish specific important task by the devil” is similar to Griffith.

              >his patronus would be a falcon

              Falcon, owl, eagle, or other predatory bird. Harry would also have platinum hair/blue eyes if he were specifically like Griffy (Malfoy is more similar to Griffith physically)

            • Obadiah says:

              My patronus would be a dark-triad shifted phoenix pre-2017–then a light-triad shifted unicorn post 2017

              Koanic’s patronus would be a wolf

              Aeoli’s patronus would be a bear (black bear at some times–grizzly bear at others)

              Tex’s patronus would be a cave bear

              Fox’s patronus would be a fox

              MM’s patronus would be an inner-city African American gentleman cracked out on bath salts

              etc

            • Obadiah says:

              “What in the name of Aeoli’s Patronus is going on in this comment section?!”

            • WW says:

              Im an alabama nigger and I wanna be free

            • Obadiah says:

              A werewolf is basically a combination of a wolf, a bear and a human. This is why werewolves are always T-fronts.

              ~Many will read, but few will repost this~

            • Obadiah says:

              MM’s patronus is “Your boy Bobby nyigguh (DWYGD)”

            • Obadiah says:

              MM’s troo patty would of course be some sort of highly-choleric unicorn (“unicorns” being the melonhead genetic group as aeoli outlined in the “twilight’s apotheosis” post. Melons will generally tend to be either unicorns or birds-of-prey/snakes. Just like MTs and TTs will tend to be wolves/bears/foxes or some permutation of those–Guts from berserk transforms into a ferocious werewolf when he is pushed too far and ‘goes berserk’. The patroni are consistent with phrenology groups because they are representations of seed/genetic data/genetic groups/patrlineages/branches of Jehovah’s tree).

            • Aeoli Pera says:

              >MMā€™s troo patty would of course be some sort of highly-choleric unicorn (ā€œunicornsā€ being the melonhead genetic group as aeoli outlined in the ā€œtwilightā€™s apotheosisā€ post.

              The blog has reached its final form.

            • Obadiah says:

              It hasn’t even begun, nigger.

            • Aeoli Pera says:

              *glows in the dark*

            • Obadiah says:

              Well I guess it’s begun seeing as you’ve been going for like 9 years now.

            • Aeoli Pera says:

              I’ve been blogging for 20 years (starting at age 12), it’s just that my previous blogs are lost to the sands of time and weren’t any good anyway.

            • Aeoli Pera says:

              Just another reason why I always encourage people to start sooner rather than later. You have to do something poorly for a really long time before you git gud.

    • MM says:

      wtf I love cigars even more now and will now inhale htem

  5. MM says:

    >sneaks into baby Popper’s bedroom
    >uses “wand” to leave a squiggly “scar” on face, but in process loses libido and thus has to kill “unicorns” (10/10 gf material) to get enough thrill to stay alive.
    (Popper was changed by the experience and is now naturally gifted at throwing powerful ropes of ‘magic’ with his wand, especially at other boys)
    >after being resurrected, exclaims in delight how he can now touch Hairy Popper again.

    ur a faggot Hairy

  6. Obadiah says:

    Ron’s patty is a “dog” but it should be a wolf (Ron is thallish).

    Ginny’s patty is a “horse” but it should be a unicorn (Ginny is more Jacob than Esau, despite being a Weasley).

    Again I think when Satan wrote HP he made these slight “one-step-off” distortions to keep the trail a bit cold/not make stuff too obvious.

Leave a reply to Obadiah Cancel reply