General

Re: concat and substring question

Jimmy — Tue, 24 Jan 2012 06:49:34 GMT

Ah, well spotted. I didn't think it through completely. Glad it worked otherwise!

Re: concat and substring question

jaxkookie — Mon, 23 Jan 2012 20:05:31 GMT

Thanks Jimmy, That was just about right, maybe was typo, the middle substring should be

substring(substring-after(TitleCase, ' '), 1, 1)

else it works perfectly.

thanks

Re: concat and substring question

Jimmy — Mon, 23 Jan 2012 17:55:24 GMT

How about this:

concat(substring(TitleCase, 1, 1), substring(substring-after(TitleCase, ' '), 2, 1), substring(substring-after(TitleCase, "+"), 2, 1))

concat and substring question

jaxkookie — Mon, 23 Jan 2012 16:28:35 GMT

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

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.