Nerd Alert: Trim trailing LF/CR characters in Oracle

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 “$”
Posted in computers/programming | No Comments »

Nerd alert: exit code 32512

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

Posted in general | No Comments »

Nerd alert: Trimming Leading/Trailing Whitespace with Regular Expressions

Find leading whitespace: ^[ \t]+

Find trailing whitespace: [ \t]+$

Posted in computers/programming | No Comments »

Nerd alert: Finding non-printing characters in varchar2 fields in Oracle

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

Posted in oracle/database | No Comments »

Summer catchup

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.
gabe and graydon click for full size!

gabe and graydon click for full size!

Posted in general | No Comments »

Not Gaines

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.
Pinnacle

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.

Pinnacle
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:
Pinnacle

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:
Pinnacle

Posted in Gabe, Graydon, general | No Comments »