Skip to content

Instantly share code, notes, and snippets.

@ateneva
Last active June 3, 2018 16:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ateneva/6f0bda0ad67bcca0771c51918d5f9e6f to your computer and use it in GitHub Desktop.
Save ateneva/6f0bda0ad67bcca0771c51918d5f9e6f to your computer and use it in GitHub Desktop.
IF left ([Title],1) = '1'
or left ([Title],1) = '2'
or left ([Title],1) = '3'
or left ([Title],1) = '4'
or left ([Title],1) = '5'
or left ([Title],1) = '6'
or left ([Title],1) = '7'
or left ([Title],1) = '8'
or left ([Title],1) = '9' then 'starts with a number'
elseif find([Title], '-') != 0 then 'contains a dash'
elseif find([Title], ':') !=0 then 'contains a colon'
elseif find([Title], ',') !=0 then 'contains a comma'
elseif find([Title], '"') !=0 then 'contains quoatation marks'
elseif right([Title],1) = '!' then 'ends with an exclamation mark'
elseif right([Title],1) = '?' then 'ends with a question mark'
elseif right([Title], 1) = '.' then 'ends with a dot'
elseif right([Title],1) != '?'
or right([Title],1) != '!'
or right([Title],1) != '.' then 'ends with no punctuation'
elseif right([Title],1) = '1'
or right([Title],1) = '2'
or right([Title],1) = '3'
or right([Title],1) = '4'
or right([Title],1) = '5'
or right([Title],1) = '6'
or right([Title],1) = '7'
or right([Title],1) = '8'
or right([Title],1) = '9' then 'ends with a number'
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment