In a SharePoint List column A, I have a avalue like:
xx|[email protected]":yy|[email protected]":
In a calculated column, I want to get email IDs with separated by a semicolon, like:
[email protected];[email protected]
Basically I want to get a string between | & :
You are limited by the Functions you can use in SP, there is no .split() function
See: https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List
You can test/develop in Excel, then copy paste your Formula to SP
PS. copy/paste that site, It will be gone 1/1/2018
