truncate the value of a SharePoint column from a character and paste it on a calculated column

%3CLINGO-SUB%20id%3D%22lingo-sub-2259442%22%20slang%3D%22en-US%22%3Etruncate%20the%20value%20of%20a%20SharePoint%20column%20from%20a%20character%20and%20paste%20it%20on%20a%20calculated%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259442%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20truncate%20the%20value%20of%20a%20SharePoint%20column%20from%20a%20character%20(ex%3A%20%22_%22)%20and%20paste%20it%20on%20a%20calculated%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20the%20right%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2259442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello :smile:

 

I would like to truncate the value of a SharePoint column from a character (ex: "_") and paste it on a calculated column.

 

Anyone know the right formula?

 

 

Thanks :)

1 Reply

@slm755 

You can use combination LEFT/RIGHT & FIND functions to extract the substring of text column.

 

For Example: You have a column with name "User" & value "John_Doe"

 

You will get "John" by using below formula:

 

=LEFT([User],INT(FIND("_",[User])-1))

 

And you can get "Doe" by using below formula:

 

=RIGHT([User],LEN([User])-INT(FIND("_",[User])))

 

ReferenceUsing calculated field to retrieve substring of another field 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.