In ORD Calculated Columns, how can we remove some characters from a string? How can we apply the function substring?
For example, the first three digits must be removed from the User System ID field.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
SAP SuccessFactors HCM Suite
This can be done from the Function Selector screen of the Calculated Column Designer when the Data Type is Text.
Open the Calculated Column Designer in ORD by clicking on the icon in the toolbar.
- Enter a Name for your calculated column and then select the Data Type Text.
- Select the field or column name which you need to remove characters from under the Text grouping. For the give example above, drag the User Sys ID field from Global Job Information into the Value box.
4. Double-click on the field you just added. The Token Editor window will display.
5. Click on Edit beside Function to open Function Selector. Here you can specify the function and the number of characters to get from the given string.
Left - get the first x number of characters from the string. E.g for the screenshot below, if the string is '123456' the calculated column will return '123'.
Right - get last x number of characters from the string. E.g. '012345', will return '2345'. This can apply when you want to remove leading characters from the string.
Middle - get x number of characters starting from position x#. E.g. '123456', below will return '234'
Report, Canvas, ORD, Online, Designer, Calculated, Column, Custom, Left, Right, Middle, Sub, string, remove, leading, Center, prefix, suffix, text, zero, calculation , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To