I have an Assigned To column which look ups emails in a contacts list. What i am trying to achieve is email these set of emails using workflows but because they are not 'Person or Group' i have to make sure the emails are correctly formatted like this:
rather than having commas as separator:
Currently I created a calculated column , i use this formula to replace the commas with semicolons.
=REPLACE([Assigned To],FIND(",",[Assigned To]),1,";")
But this only replaces the first instance of comma, and because Assigned To column does not have a fix number of emails, if it has one email or more than 2 emails, this calculated column will not work and the workflow sending the email will product an error.
If there is more than 2 emails it will only replace the first instance of comma
If there is only 1 email, the column will not change and show up as #Name?
One possible workaround is having IF statement and counting the number of occurrence of ',' and looping for that amount of times. Unfortunately counting occurrence is also not OOTB for calculated columns.
Is there any way i can change all commas to semicolon using OOTB ways?I know using SharePoint Designer 2013 workflows might be able to do this but my company only has 2010 workflows and i have no authorization to download 2013 workflows. I am not familiar with VS so i might need step-by-step guide on VS event receiver etc.
Thanks in advance !!