AnsweredAssumed Answered

Removing space from result of text calculation for changing order first and last name

Question asked by willem67 on Jun 20, 2013
Latest reply on Jun 23, 2013 by willem67

Title

Removing space from result of text calculation for changing order first and last name

Post

      

     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:
     Smith, John
     Johnson, Jane
     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 )

Outcomes