© Matti Mattila, CPFA, CISA, CIA

TexEdiMac: Change to Uppercase or to Lowercase

Previous item Previous menu
Test Design
Picture 1
- In picture 1 a file (source file) is shown that will be used in demonstrating 'Change to uppercase or to lowercase' functionality of 'TexEdiMac' (later renamed as 'TexEdi') macro.
- The objective is to change first names in the source file to small letters, except the first letter that shall be as it is.
- The lines of the source file vary in length. However, all surnames begin at position 19.
Start the run
- The easiest way to run the macro is pressing simultaneously Ctrl + Shift + 't'.
Picture 2
Picture 5
Picture 7
- At the beginning of the run the macro shows the user the form in picture 2. Select 'Change to Uppercase or to Lowercase' on it.
- You will see information what the macro does (picture 2a: [1]). Read the it, and proceed by clicking 'Yes'.
- You will be asked to select a file, where to to change text to uppercase or to lowercase. Please, click 'Yes' ('Kyllä' = 'Yes' in picture 3) in order to proceed.
Picture 3
Picture 4
- We search for 'test.txt', and find it located in folder 'ChaCas' (picture 4). We select the file.
- The macro suggests a name to the new file: the body of the name of the source file, with a bit different extension.
On the form (picture 5), where the file name was suggested, you can change the extension of the [resulting] new file, if you do not want it to be 'tx9'. You do not need to write anything in the box 'File extension is stead of 'tx9'' when you decide to use extension 'tx9' [2].
- The macro will inform, what will be the path and name of the resulting file (not shown in pictures; it would be: 'D:/ChaCas/test.tx9').
- The macro asks input for making the uppercase/lowercase change (picture 6)
We want a copy of the source file, where all the text between positions 2 to 18, those positions included, will be in lowercase letters. We do not want other changes.
Picture 6
- After inputting the information, click 'Proceed', and the change will take place, and the macro informs about it.
The new text file
- In picture 7 such a file resulted in the test above has been opened. It has 6 lines with desired lowercase cahnge.

[1] Text (to the left) on 'Guidance' worksheet of 'TexEdiMac.xls': what the macro does.
Picture 2a
[2] The macro does not use special characters in an extension.