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