Removing space from result of text calculation for changing order first and last name
In my database first and last names of authors are entered in one field. In reports I would like to swap the order.
Name are entered like:
Peterson, Mary Ann
The calculation I use works well. It only leaves one space in front of result. How can I remove the space?
Right ( Authors ; Length ( Authors ) - Position ( Authors ; ", " ; 1; 1 ) )
Left ( Authors ; Position ( Authors ; "," ; 1 ; 1 ) -1 )