How can I replace ";" in a text like this with " AND " ?
example text: "abc;cde;efg;ijk" the result should be like this: "abc AND cde AND efg AND ijk"
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityHow can I replace ";" in a text like this with " AND " ?
example text: "abc;cde;efg;ijk" the result should be like this: "abc AND cde AND efg AND ijk"
Try this:
=REPLACE([YourColumnname],FIND(";",[YourColumnname]),1," AND ")
This should get you going in the right direction. Calculated Field Formulas
The column "NewColumn1" is using the exact formula as above, and was created from the SharePoint Designer. I Don't know why it did not work from the UI. I'm using the default language pack.
EDIT For sites using english as a regional setting "," work's, but any regional setting need to use ";" instead.