Reply to "Blank Space"
sorry. I'm on iOS and had to create a new post to reply.
Phil, I believe you meant "<".
I'll find the thread and update it. Thanks for the heads up.
And you can also "reply" via private message.
I went and looked at it, and nope, I meant >
If ( Length ( self ) > 12 ; self ; Right ( "000000000000" & self ; 12 ) )
If self is longer than 12 characters, leave the value unchanged. If it is 12 or less, pad with leading zeroes.
I could reverse the inequality, but then I'd need to swap the result clauses and that would definitely be "6 of one" vs. "Half dozen of the other".
Retrieving data ...