Only Show first letter of name

[cutpen]

What is the formula to only show the first letter of a name?

Thanks

 

[lbass]

Why are you asking this again? See your own thread:
thread767-1482317

Note that is also a good idea to reply to threads you have started. I noticed you started some threads without ever replying.

-LB

 

[AngChristman]

You would do this by:

{Field_1}[1]

Ang

 

[cutpen]

I am very sorry if I have affended anyone by not replying. I am new at this. I have used what was given me and it did not work. I guess it is because I am trying to concatenate it to others see below.
{hrpersnl.p_lname}&" "&{hrpersnl.p_fname}&" "& left{hrpersnl.p_mi,1}

 

[lbass]

When something doesn't work, you should report back showing what you tried so that people can troubleshoot for you. In the above, you have not used the parens correctly, and have added the one in the wrong place. Use:

{hrpersnl.p_lname}&" "&{hrpersnl.p_fname}&" "& left({hrpersnl.p_mi},1)

If the middle name can be null, use:

{hrpersnl.p_lname}&" "&{hrpersnl.p_fname}&
(
if isnull({hrpersnl.p_mi}) then "" else
" "+ left(({hrpersnl.p_mi},1)
)

-LB

 

[cutpen]

Thank you, it worked and I hope you have a good day