coldfusion example

[scottobear]

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.