SOLVED

Split the column based on delimeter

New Contributor

hi 

i have a column in sharepoint list in format "CAN-DOM-2022-001"

now i want to create another column which extracts the the last 3 digit of the data like 

"001"

 

how can i do using a calculated column in sharepoint list 

3 Replies

@Battu1984 Try using formula like below in calculated column: 

 

=RIGHT([Column 1],3)

 


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.

@ganeshsanap 

no it didnt work 

Battu1984_0-1660225612017.png

 

Battu1984_1-1660225631039.png

 

best response confirmed by Battu1984 (New Contributor)
Solution

@Battu1984 Security validation of page is expired - you must have kept this page open for longer time.

 

Try this: 

  1. Go to list settings page again
  2. Click on create column link
  3. Select data type as calculated column
  4. Use the formula in above format & click Save/OK

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.