unknown dog

Lots of Nerd Alerts lately, but I haven’t unloaded the camera to see which family pics turned out to be in focus…

PROBLEM: Your data has zero or more trailing commas followed by a non-printing character, typically LF/CR.

SOLUTION: regexp_replace!

regexp_replace(a.SOME_COL,',*[^[:print:]]$','') as SOME_COL

The regular expression breaks up like so:

',*[^[:print:]]$'

1. ,* means look for zero or more commas, followed by…
2. [ ] …the contents of the brackets, which breaks up as
• ^ means not the things in the inner brackets
• [:print:] is the class of printable characters
3. $ …leading to the end of the line, which in regexp speech is “$”

Means file doesn’t exists or the path has been defined incorrectly.

Find leading whitespace: ^[ \t]+

Find trailing whitespace: [ \t]+$

How to find non printing characters using instr and regexp_instr in Oracle databases:
Read more »

Earlier this summer, we took the kiddos to Robinson Center for a showing of Nick Jr. Live. Pretty cool stuff- fun for the kids, tolerable for the adults.

Inside pictures were terrible- went 0-for-everything. The outside pictures gave up a couple of keepers:
Click the zoom icon for full size.

Now that we are done with Gaines for the moment, we have more time for the kiddos. We decided to take them to Pinnacle Mountain this past weekend.

We packed a picnic lunch and took them down the Kingfisher trail. easy cheesy.

Despite going during the heat of the day, we managed to hear a few different birds, see squirrels, interesting insects, some fish in the water, huge and very cool cypress trees.

We conducted some serious searching, but we never found Peter Rabbit under any of these big old trees.

The kiddos were troopers, despite the heat, and even sorta almost could be convinced to pose for a picture:

It isn’t exactly obvious from the picture above, but Graydon had the most hilarious “it-is-freaking-hot-and-go-to-hell-with-this-picture-taking-business” look on her face: