Click here to Skip to main content
16,016,678 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a CR that I am working on. I have a Prefix data field, First Name data field and Last Name data field. On the report they look like this:

Dr.MarkFun

I am trying to get it to look like this:

Dr. Mark Fun

I am using this Formula to trim it:
C#
Trim({TableCEO.Prefix})&trim({TableCEO.FirstName})&trim({TableCEO.LastName})

Which works fine but I get this:

Dr.MarkFun

I tried to use this:

C#
Trim({TableCEO.Prefix})&trim({TableCEO.FirstName}+space(30-length)&trim({TableCEO.LastName}))


The error comes up saying: "Not enough arguments have been given to this function."

How can I get the result I need for the report? What did I do wrong in my code?
Posted

1 solution

I got it fix!! Here is my formula:

Trim({TableCEO.Prefix})&" "&trim({TableCEO.FirstName})&" "&trim({TableCEO.LastName})

That gave me

Mr. Mark Fun
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900