562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Imagine an alternative universe in which Nigel Farage (remember him?) had been elected as Prime Minister, and in which it was now mandatory to keep a copy of files with names containing the letters UK in a separate folder.
Create a package called Housekeeping, and within this a string variable called FilePath to hold the name/path of each file that you find:
Make sure you put something for the variable value.
Create a new folder called Copied files on your computer's desktop.
Loop over all of the files on your USB stick (or in the folder on your computer containing the files for this course), finding the ones whose names contain the letters UK and copying them to your new Copied files folder:
The comment shown here is an annotation, to explain what the expression constraint is doing. The package should loop over all of the files in the folder containing your course files, checking to see if each contains the letters UK (see expression below) and copying it to your new folder if it does.
Here's what you could put for the expression constraint:
FINDSTRING(UPPER(@[User::FilePath]),"UK",1) > 0
When you've got this working, delete the folder and close down your package.
25 Aytoun Street