© Matti Mattila, CPFA, CISA, CIA

Possible problems in running the script

Previous item Next Item Previous menu

(02.02.2004)

NOTE! Some of the information here applies only to CROMM source code.

The script does not summarise numeric fields properly.

-

This is likely due to the separator ';' used in IDEA functions. To correct it replace ';' with ',' or other proper separator.

-

Replacement is easy to do using IDEA's replace function [Edit - Replace - Find What: ; Replace With: ,].

The script stops in error

Likely causes to this are among the following:

-

There are special characters (e.g. &, %) among the characters of 'Char. field B' (columns). [Error message: Method exception:].

-

To circumvent the problem use a field containing special characters as 'Char. field A'. Should both 'Char. field A' and 'Char. field B' contain special characters replace them in the field that you are going to use as 'Char. field B': make a virtual character field and give it value through IDEA's function '@replace'or '@stip' [1]. If you wish you can change later places of rows and columns e.g. in Microsoft Excel (paint the table and select: 'copy, transpose...').

Truncation level

The maximum truncation level (default: 20) of character fields selected in analysis can be easily changed, if you wish to. Use IDEA's find function [e.g. Edit - Find - Find What: 20] to find the number to be changed and replace it with the number you prefer .

Announcement: 'Registration failed. Please contact Technical Support.'

See a helpful TIP! on the previous page.


[1] E.g. to replacement of '/' with '_' in 'DESCRIPTION" field would happen using equation @replace(field_name; '/';'_'). If the field contains many different special character 'stip' funtion can be used (e.g: @strip( "ab#$12&" ) returns "ab12").