Forum Discussion
Split the column based on delimeter
Battu1984 Security validation of page is expired - you must have kept this page open for longer time.
Try this:
- Go to list settings page again
- Click on create column link
- Select data type as calculated column
- 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.
Battu1984 Security validation of page is expired - you must have kept this page open for longer time.
Try this:
- Go to list settings page again
- Click on create column link
- Select data type as calculated column
- 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.
What about if you need to split more than once. see my example below for what I want to do.
| code (needs splitting) | Con | Site | Build | Room | Equip |
| R | R | ||||
| R-BRMP01 | R | BRMP01 | |||
| R-BRMP01-BR001 | R | BRMP01 | BR001 | ||
| R-BRMP01-BR001/700000704 | R | BRMP01 | BR001 | 700000704 | |
| R-BRMP01-BR001-L0-001 | R | BRMP01 | BR001 | L0-001 | |
| R-BRMP01-BR001-L0-001/700005253 | R | BRMP01 | BR001 | L0-001 | 700005253 |
What I have sort of working.
| Equip | IFERROR(RIGHT([@code],LEN([@code])-FIND("/",[@code])),"") |
| Room | ??? |
| Build | ??? |
| Site | IFERROR(LEFT(RIGHT([@code],LEN([@code])-FIND("-",[@code])),FIND("-",RIGHT([@code],LEN([@code])-FIND("-",[@code])))-1),"") |
| Contract | IFERROR(LEFT([@code]),"") |