| - |
Examine whether parameters for the run are correct in the cell area 'B15:B18' of 'Guidance' worksheet.
(In 'TexEdi' that is included in 'ExcAud', the parameters are located in cells 'B27:B29'
of 'Guidance'.)
|
 |
| Picture 2 |
|
 |
| Picture 3 |
|
 |
| Picture 6 |
|
|
| - |
Please note that the macro removes thousands separators from any string containing numbers
[anywhere on a line].
|
| - |
According to the defaults (picture 2) decimal commas (,), periods (.) and minus signs (-)
shall be left in text containing numbers.
Decimal separator (here comma) must be in the first position in cell 'B16'.
|
|
| Running the macro
|
|
| - |
The easiest way to run the macro is to press simultaneously Ctrl + Shift + 't'.
|
| - |
At the beginning of the run the macro shows the user the form in picture 3.
Select 'Remove Thousands separator from Numbers', and click 'Proceed'.
|
| - |
The macro informs what it does (picture ra: [2]).
Read the message, and click 'Yes' in order to proceed.
|
| - |
The macro asks to select a source file (picture 4).
|
 |
| Picture 4 |
|
 |
| Picture 5 |
|
| - |
We browse and find 'test1.txt' in folder 'CleNum' (picture 5),
and select that file.
|
| - |
The macro suggests a name to the new file: the body of the name of the source file,
with a bit different extension ('tx9 in stead on 'txt' in the example).
|
|
On the form (picture 6), 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' [3].
| - |
The macro will inform, what will be the path and name of the resulting file
(not shown in pictures; it would be: 'D:/CleNum/test1.tx9').
|
| - |
At the end of the run the macro gives a message that the new file is ready.
|
| - |
We make still another run using source file in picture 1
after having removed decimals from amongst the numbers.
|
|
| The new text files
|
| - |
Pictures 7 and 8 are about the two new text files
that resulted from the two run of the macro.
|
| - |
The file in pictures 7 is what we wanted: thousand seperators are away.
The file is relatively easy to read into a normal CAATs software.
|
