SUBSTR, SCAN, TRIM, COMPRESS, LEFT, RIGHT, CATX, INDEX, FIND, UPCASE, LOWCASE, PROPCASE and TRANWRD

Each function is introduced in standard syntax form, illustrating both the required arguments and any optional arguments which are available with an explanation of their purpose.

This is followed by an example of each function in action using data from a simple dataset.

There are also mini quizzes and comprehensive exercises throughout to help assess and reinforce your learning.