Task 1. Create Expression Rules and Run the Profile
In this task, you create two expression rules to parse the FullName column into two virtual columns named FirstName and LastName. The rule names are FirstName and LastName.
1. In the Library workspace, click the Profile_LA_Customers profile.
The profile results appear in summary view.
2. Click Edit.
The Profile wizard appears.
3. Click Specify Rules and Filters screen.
4. In the Rules pane, click Actions > Create Rule.
5. In the Name field, enter FirstName.
6. In the Expression section, enter the following expression to separate the first name from the Name column:
SUBSTR(FullName,1,INSTR(FullName,' ' ,-1,1 ) - 1)
7. Click Validate.
8. Click OK.
9. Repeat steps 4 through 8 to create a rule named LastName. Enter the following expression to separate the last name from the Name column:
SUBSTR(FullName,INSTR(FullName,' ',-1,1),LENGTH(FullName))
10. Click Save and Run to save and run the profile.