In this eLearning module you will learn how to transform character data using a variety of useful functions including:
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.
You will also get access to 6 x Reference modules – 3.5 hours worth of additional support.