Separate First Name and Last Name without Space 1

[gsmithmme]

I am using Crystal 8.5 with a Paradox database. I have a field with a full name (Fred Bloggs) and I need to create a salutation in a cover letter. "Dear Fred," Currently, I use this formula:

"Dear " +Left({Jobs.Contact},InStr({Jobs.Contact}," "))+","

However, when it runs it shows

Dear Fred , instead of Dear Fred, (notice the space after Fred?)

Looking for a way to remove the space. I tried inserting formula into a text box and adding the , but the space is part of the formula.

Any suggestions are appreciated..

 

[briangriffin]

You were so close -

"Dear " +Left({Jobs.Contact},InStr({Jobs.Contact}," ")-1)+","

 

[gsmithmme]

Ta da! Thanks Brian.. Tell Stewie I said hey! (I knew Peter could never handle that!)