Home

Remove spacing in text column

%3CLINGO-SUB%20id%3D%22lingo-sub-857699%22%20slang%3D%22en-US%22%3ERemove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857699%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20have%20a%20simple%20single%20line%20text%20column%20for%20email.%20The%20email%20address%20is%20essential%20for%20running%20a%20Power%20shell%20script%20so%20it's%20important%20is%20captured%20correctly.%20However%2C%20We've%20noticed%20some%20users%20entering%20spaces%20before%20and%20after%20the%20email%20address%20(most%20likely%20copying%20and%20pasting)%20which%20is%20causing%20issues%20with%20the%20script.%20How%20can%20I%20format%20the%20column%20to%20Trim%20the%20spacing%20before%20and%20after%20the%20text%20so%20that%20there%20is%20no%20spacing%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-857699%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857938%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857938%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409658%22%20target%3D%22_blank%22%3E%40SPFlowy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20add%20a%20calculated%20column%20to%20the%20list%20that%20uses%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ftrim-function-50b6f593-4801-4f06-81c5-3345e7f80ddd%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETRIM%20function.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863503%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response%20however%20It%20does%20not%20seem%20to%20be%20working%20for%20me%20-%20the%20spaces%20still%20appear%20even%20after%20adding%20the%20TRIM%20function%20to%20the%20calculated%20value.%20How%20would%20Formula%20look%20on%20a%20single%20line%20of%20text%20column%3F%3C%2FP%3E%3CP%3EAppreciate%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863536%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409658%22%20target%3D%22_blank%22%3E%40SPFlowy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132627i36F1FC32A12FB23B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20TRIM%20is%20not%20working%20I%20think%20there%20might%20hidden%20characters.%20View%20the%20email%20values%20in%20text%20editor%20that%20allows%20you%20to%20view%20hidden%20characters%20(i.e.%20NotePad%2B%2B).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
SPFlowy
New Contributor

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

3 Replies

Hi @SPFlowy,

 

You could add a calculated column to the list that uses the TRIM function.

 

I hope this helps.

 

Norm

@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. 

@SPFlowy,

 

clipboard_image_0.png

 

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

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies