Contents
How to remove the first space in a calculated column?
In the first calculated column (C1) I entered a formula to remove the first space, something like this: In the second Calculated column (C2) I used:
In “The data type returned from this formula is” option by default, it is showing a single line of text. Click on “OK”. In the below screenshot we can able to see EmployeeFullName in SharePoint “EmployeeFullNme” list. Here in the SharePoint list, I have below columns: Month (Calculated Column) The formula for the Year calculated column as:
How to calculate column replace all in SharePoint?
Seems like it would be a simple thing really (and it may be), but I’m trying to take the string data of a column and then through a calculated column, replace all the spaces with %20’s so that the HTML link in the workflow produced email will actually not break off at the first space. For example, we have this in our source column:
What can you do with a calculated column?
By using a calculated column, you can create a formula that includes data from other columns and performs functions to calculate dates and times, to perform mathematical equations, or to manipulate text. Calculated columns can only interact with an item, it cannot interact with another row or item.
The standard solution for this situation is using an ItemAdded (/ItemUpdated) event and initializing the field value from code. I was able to solve this issue for my circumstances by using a series of calculated columns. In the first calculated column (C1) I entered a formula to remove the first space, something like this:
How to replace a space in a string?
Any formula that will replace the first occurrence of a space with “%20” will work, the trick is to a) make sure the formula returns the original string unchanged if it does not have more spaces in it, and b) test, test, test.