RIGHT
Overview
Extract a sub-string from the RIGHT of a string.
Creating a RIGHT formula
To create a RIGHT formula:
- With a chart open, select the DOCUMENT RIBBON
- Click on the Fields button
- Click on Add formula button
- Select the RIGHT menu item
- Select the Field to extract a sub-string from (e.g. SSN)
- Select the Range by entering an integer value or character (See options below)
- Click OK
- Rename the formula (e.g. 4digSSN)
- Click OK to complete the rename function
- Click OK (green button at the top)
Options
When creating a RIGHT formula, you can enter the range to include in the calculation.
The following options are available:
- Positive integer value - Displays a number characters starting from the right of the field equal to the value entered. (e.g. If "4" is entered with the with the SSN field it will return the last 4 characters of SSN.)
- Break character - Displays all characters to the right of entered character. (e.g. If "@" is entered with a field containing e-mail addresses then all characters right of the "@" will be displayed.)
RIGHT Examples
Here are some examples of the RIGHT formula.
- RIGHT using "@" as the break character would yield orgchart.com given an input of moc.trahcgro|naD#moc.trahcgro|naD.
- RIGHT using "4" as the integer value would yield 1234 given the SSN xxx-xx-1234.
Reviewed 9/4/2017