Matches the right set of characters in a string, as specified by parameter. The string can be specified as a column reference or a string literal.

Column reference example:

right(MyString,3)

Output: Returns the rightmost (last) three letters of the MyName column value. 

String literal example:

right('Hello, World',5)

Output: Returns the string: World.

right(column_string,end_count)


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function
end_countYinteger (positive)Count of characters from the end of the source string to apply to the match

column_string

Name of the column or string constant to be searched.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

end_count

Count of characters from the right end of the string to include in the match.

Required?Data TypeExample Value
YesInteger (non-negative)5

Example - Parse segments of social security numbers

Social security numbers follow a regular format:

XXX-XX-XXXX

Each of the separate numeric groups corresponds to a specific meaning:

Source:

You want to analyze some social security numbers for area, group, and serial information. However, your social security number data is messy:

NOTE: The following sample contains invalid social security numbers for privacy reasons. If you use this data in the application, it fails validation for the SSN data type.

ParticipantIdSocialNum
1001805-88-2013
1002845221914
1003865 22 9291
1004892-732213

Transformation:

When the above data is imported, the SocialNum column might or might not be inferred as SSN data type. Either way, you should clean up your data, using the following transforms:


At this point, your SocialNum data should be inferred as SSN type and consistently formatted as a set of digits:

ParticipantIdSocialNum
1001805882013
1002845221914
1003865229291
1004892732213

From this more consistent data, you can now break out the area, group, and serial values from the column:


If desired, you can re-order the three new columns and delete the source column:


Results:

If you complete the previous transform steps, your data should look like the following:

ParticipantIdSSN_areaSSN_groupSSN_serial
1001805882013
1002845221914
1003865229291
1004892732213