Forum Discussion

SPFlowy's avatar
SPFlowy
Copper Contributor
Sep 16, 2019

Remove spacing in text column

Hi,

We have a simple single line text column for email. The email address is essential for running a Power shell script so it's important is captured correctly. However, We've noticed some users entering spaces before and after the email address (most likely copying and pasting) which is causing issues with the script. How can I format the column to Trim the spacing before and after the text so that there is no spacing?

Many thanks

Lists
SharePoint Online
    • SPFlowy's avatar
      SPFlowy
      Copper Contributor
      Sep 19, 2019

      Norman Young 

      Thanks for your response however It does not seem to be working for me - the spaces still appear even after adding the TRIM function to the calculated value. How would Formula look on a single line of text column?

      Appreciate your help. 

      • Norman Young's avatar
        Norman Young
        MVP
        Sep 19, 2019

        SPFlowy,

         

         

        If TRIM is not working I think there might hidden characters. View the email values in text editor that allows you to view hidden characters (i.e. NotePad++).

         

        Norm

Resources