2 Replies Latest reply on Jun 23, 2013 2:15 AM by willem67

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

    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 )