0

In a SharePoint List column A, I have a avalue like:

xx|myemail1@email.com":yy|myemail2@email.com":

In a calculated column, I want to get email IDs with separated by a semicolon, like:

myemail1@email.com;myemail2@email.com

Basically I want to get a string between | & :

moe
  • 5,267
  • 21
  • 34
Pramod Gupta
  • 55
  • 6

1 Answers1

1

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

Danny '365CSI' Engelman
  • 21,176
  • 7
  • 35
  • 79