2 Replies Latest reply on May 17, 2010 9:31 PM by user447

    How to delete a space from the middle of a date

    user447

      Title

      How to delete a space from the middle of a date

      Post

      I've imported several date fields and many were originally entered with an extra space within the date.  For instance:  7/ 3/ 08

      A calculation based on that field will not work unless it is retyped or re-entered as 7/3/08 with those extra spaces deleted.

      How can I remove them?  Isn't TrimAll just for leading and trailing spaces?

      Thanks for any suggestions!

      Jane in LR