I have several forms where I generate a ticket number. the form type is part of the ticket number. I want to get the first letter of each word from the form type, but I believe I may need some kind of an if statement. for example here are 4 types
-
Primary
-
Primary + Transportation
-
Transportation
-
Other
what I need to return is
-
P
-
P+T
-
T
-
O
there may also be some types with a hyphen.
Is there a way to check for a specific character or count spaces and when greater than 1 I can do something like this:
concat(substring(TitleCase, 1, 1), "+", substring(substring-after(TitleCase, "+"), 2, 1))
and when no spaces I can do this:
substring(TitleCase, 1, 1)
Unless I am way off and there is a simpler way.