|
<< Click to Display Table of Contents >> Navigation: User guide > Introduction > Recent Enhancements |
CL is now a Unicode program provided RCP UNITEXT is used and scripts are UTF-8 encoded. There is then no longer any need to set the Locale in the Control Panel unless you have ASC data with non-English text. CL will also now work with UTF-8 set as the Locale.
Please use Companion Reflect which replaces the classic QPSMR Reflect.
Significance markers are now output to the CSV tables preceded by a space - for example now " aB", not "aB" to avoid a problem with Excel.
We recommend the use of the UNITEXT RCP for all projects.
We recommend that all CL script files are now stored as UTF-8 encoded (use Notepad).
Conversion and formatting of CSV tables to Excel is much faster using Companion.
Use Companion 24.1 or above to run scripts (extended version) or convert CSV tables files to Excel.
CL can now handle any text in cvars, see Character data for the important difference between ASC and UNI data files
UTF-8 encoded scripts can now be used without a BOM (byte order mark)
New setting E on RCP CSV2 to output a blank for empty markers.
New RCP BINARYDATA which tells CL that the data files will be in binary format.
New RCP MARKERSEP which puts a dot between significance markers and sets the maximum characters in column identifiers.
Allows up to 4 character column identifiers. See Format SHG for information about column identifiers.
The following file extensions should now be used for CL script files:
.stpx for the main CL script which contains the control stage.
.stp for [*insert] CL scripts.
If using Companion to convert tables to formatted Excel, use RCP CSV2I... to output Information lines. These will be used by Companion to control the cell formats used in Excel.
2022.1f. New character format CMS, default CMS'~', sets the character to use for cells hidden under RCP MINSHOW.
2022.1e. Maximum record length for data files is increased to 350000.
2022.1e. Column identifiers for significance marking can now use letters in any language that have upper and lower case equivalents, including those with diacritics see Format SHG.
2022.1d. New label control <&SHEET> to control CSV tables to Excel using Companion (no Companion licence needed)
New RCP UNITEXT (recommended) makes CL run as a Unicode program when not using binary data files.
If UNITEXT RCP is used and CL script and data files are UTF-8 with BOM or UTF-16 with BOM:
You no longer need to set the Locale in the Control panel.
Character variables and data files can handle any languages.
All output files are now Unicode UTF-8 encoded with BOM, unless UNICODE16 RCP is used.
CSV tables can be formatted in Excel (OpenXML) using Companion (no Companion licence needed).
SPSS export now adds SCORE variables containing the score value for variables with <V> (score value for averages).
The output tables CSV file is now Unicode UTF-8 encoded with BOM, see UNICODE.
%RIM now shows weighting efficiency in the log file.
2020.2f. New CSV2 settings.
New setting of +?+ to test a column against all following columns, see format SHG.
2020.1j. New overlap formula settings for formats SIG and TTV
2020.1j. New format MCM to set minimum column base for mean score significance tests
2020.1f. Short SERIAL command for CSVDATA that contains serial numbers
Default for format SHG is now SHG11.
Format setting TTV0 suppresses significance testing on mean scores/averages
Using <b> in rows causes an RT line to be output to the CSV tables file
2019.2g. New RCP CSV2Z option to use zero formats CAZ, CNZ and CZP in the CSV tables output.
New format UAU is now needed to use underscores around text for underlining, see Underlining text.
RCPs NOPPINDB and NOPPINCSV are deprecated, please use preprocessor commands *NOPPINDB and *NOPPINCSV instead.
New preprocessor command *PPINFO for extra information during preprocessing.
2019.1h. New format SIG settings to use t tests instead of Z tests when testing table rows.
2019.1d. Default formats changed to SMA'+'/SMB'+'/ESS, see formats SMA, SMB, and ESS.
CL can now read STP scripts and CSV data as UTF8 files and Unicode files with the appropriate BOM.
Companion portable CSV data files can now be processed with CL, see RCP CSVDATA.
Individual data files such as the CATI Partial file can be marked as fixed length, see RCP C (cards).
2018.2h. Format PUC now honoured in CSV tables, output as a UC row.
CL is now a 64 bit program.
2018.1u. New format ANV excludes records with undefined value used as rows of VDT tables.
Existing STP files can be run using the Companion with an appropriate licence.
Tables CSV files can be converted to Excel/OpenXML files using the Companion.
Reflect databases now create .qrfx files.
You can now test against the total and other columns at the same time using formats SHG11-13, for example SHG11/SMA'+'/SMB'+'.
Text embedded within string definitions can now use colon (:) or semicolon(;) as the separator.
Serial numbers can now be up to 15 digits.
New DJ $ivar = to define an integer variable that can hold up to 15 digits, see $ivar and iconstant.
CSV tables output now has option CSVG to put format FSL sig level information only in the job header.
CSV output now shows additional SHG column markers (+...+) with RCP CSV2L.
The main STP file can now be Unicode (not UTF8) text.