Display first letter only

[tmas73]

What would be the calculation to display only the first letter in each word?

?? Left ( order_quantities::orders_name; 1 ) ??

Thanks

[David Jondreau]

When dealing with having to perform a function on an unknown number of entities, in this case, Left() on an unknown number of words, a recursive custom function is usually needed.

[tmas73]

When dealing with having to perform a function on an unknown number of entities, in this case, Left() on an unknown number of words, a recursive custom function is usually needed.

Thanks DJ

What would a custom function like this look like?

[comment]

When dealing with having to perform a function on an unknown number of entities, in this case, Left() on an unknown number of words, a recursive custom function is usually needed.

Usually, yes - but not in this case:

http://www.fmforums.com/forum/showpost.php?post/288567/

[David Jondreau]

You know what's funny (well to me)...I actually cut this line from my original response:

"But I'm sure comment will have a clever way of accomplishing this with a simple calculation."

That's verbatim from a sticky I use to compose my forum posts.

I didn't want to seem pandering. :(

[comment]

Well, this one is Daniele's, not mine. I'm surprised you didn't remember it, since you helped to simplify it in the original thread:

http://www.fmforums.com/forum/showtopic.php?tid/192288/

I didn't want to seem pandering.

Pandering to what?

[David Jondreau]

Maybe I'm not using the word right, doesn't it have the sense of "providing excess flattery?"

[comment]

Ahm, no. BTW, you're welcome to provide excess flattery at any time. Actually, I don't mind if you pander to my wicked desires either - I'd just like to be clear on which one is it. :(

[Vaughan]

OK I'm getting a mental picture of you guys sitting around in black and white furry bear suits chewing on bamboo... am I warm?