Feb. 3rd, 2015

My tweets

Feb. 3rd, 2015 12:00 pm
scottobear: (Default)
Read more... )</lj-cut
scottobear: (Default)

string manipulation -

left(event_desc,iif(find(".",event_desc,100) eq 0,500,find(".",event_desc,100)

return the following string from event description -

if the leftmost 100 characters of the text contains a period and is the only period within the first 500 characters, give the text up to the period, otherwise, return the text up to the second period.

Nicely done – saves having to run a loop or step function.

Originally published at The Scotto Grotto. You can comment here or there.

scottobear: (Default)

cat-overload:

That layered makeup really works miracles..

from Tumblr http://ift.tt/1xgNnxI
via IFTTT

Originally published at The Scotto Grotto. You can comment here or there.

Profile

scottobear: (Default)
scott von berg

April 2017

S M T W T F S
       1
2 345678
9 10 11 12 13 14 15
16 1718 19 20 21 22
23 2425 26 2728 29
30      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 13th, 2025 02:02 pm
Powered by Dreamwidth Studios