Formula Needed: Blank Spaces

[JMB7]

Crystal 8.5

Hello,
I wrote a report that lists last name, first name. Some names have been entered with a single or double space before the name to differentiate them from the rest.
Need to eliminate these spaces to have all names correctly listed alphabetically.

Any help would be appreciated. Thank you

 

[glalsop]

You could try:

trim({table.lastname}) + ", " + trim({table.firstname})

-Gary

 

[JMB7]

It worked! Thanks for your help Gary

 

[JMB7]

I reviewed the report again - the trim statement worked but unfortunaltely the names that had the spaces are still listed at the top. The name that had 2 spaces is followed by the names that had one space, which are then followed by the names without spaces. I have the report sorted in ascending order by name.
Is there something I am missing in the formula?
[ trim({pract_mstr_orgz_v.pract_rpt_name}) ]
(I did not use first name, last name because they are combined in the same field.)
Thanks - Jean Marie

 

[glalsop]

You should sort by the formula, not by name.

-Gary

 

[JMB7]

Thank you again for you help.
Jean Marie