Chapter 8 - Reference

List of Survey Functions
July 1999

This is the new list of Functions available to the Survey program.
This list is an integration of the former Calendar Functions list and the Keyword Codes list.

To use one of these functions in the Manager, choose the Functions question type and place the function along with its syntax in the text field of the question record.

All of the following functions are available in the Windows 16-bit version and the 32-bit version. Click on one the above list's name to view earlier documentation.

Go back to the Table of Contents

List of Functions

ADD YEARS Add n years to a date

AGE (SINGLE) Single age calculations

AGE (ARRAY) Array age calculations

APPEND TO FILE Append symbol contents to a designated file.

APPEND TO ROSTER Append records to a roster matching an expression.

BLANK Blank out one or more sections of the Save Array code.

CHECK Check for a non-blank character in a string. Opposite of EMPTY.

CLEAN ROSTER Delete everything in a roster.

CLEANSTRING Clean and save contents of a symbol or response to a question.

CLONE Create an exact duplicate of a roster.

CODE Convert a character string into the corresponding code.

COMBINE Combine calendar

COMPRESS ROSTER Compress lines out of a roster if a field is blank.

COPY FILE Copy from one file name to another. (For example, copy information sheets.)

COUNT Count number of occurrences of a token in a range of the Save Array.

CREATE Create new calendar

CREATE DCODE Create a Pick List record from a file.

CTRLTO Pass control to a DOS program, Do not return automatically to Windows when finished.

DATE2DAY Date conversion

DATE2WK Date conversion

DAY2DATE Date conversion

DECODE Convert a code into a corresponding character string.

DELETE DCODE Delete a Pick List record in the Pick List database.

DELETE FILE Deletes a file if the file exists.

DELETE LINES FROM ROSTER Delete rows (records) from a roster.

DIFFAGE Calculate differences in dates

EMPTY Check for a blank character in a string in the Save Array.

EXECDOS Pass control to a DOS program. Do not return automatically to Windows when finished.

EXECWINDOWS Pass control to a Windows program, wait, return when finished.

EXPAND Expand multiple Select Option responses in Save Array.

EXPANDDATE Date expansion

FINDGAPS Create gap table

FIXDAY Repair a day in a date

FIXMONTH Repair a month in a date

FIXYEAR Repair a year in a date

GET VALUE FROM CODEALL Get an option selected in a Code All that Apply.

GETSUBDATE Extract part of a date

INFOSHEET Create items on an information sheet.

INIT Initialize calendar

INLIST Find if an encrypted answer to code all that apply.

INPATH Check for occurrence of question name(s) in the path.

INSTRING Check for occurrence of target string in source string.

ISCOMPLETE Check for a completed date

ISMARKED Check range for marked dates

LOCATE RECORD Search external file for a record and copy it contents

MARK Mark segments

MAX Find if the maximum number is a range of the Save Array.

MIN Find if the minimum number is a range of the Save Array.

PRINT Print a string with substitutions made in it.

READ Read contents of file or portion thereof into Save Array location.

RECCOUNT Count the number of records in a roster.

REPEAT Initiate a loop of questions.

RUN Runs other FoxPro-based software.

SET LANGUAGE Set prompt and questionnaire language.

SET NAME Specify screen display header.

SET ROSTER FIELD VALUE Set a roster field to a constant value in all rows

SET SEPARATOR Set date separator, e.g., '-' or '/'.

SET SOUND Enable or disable the sound.

SORTROSTER Sort fields in roster by a key.

STATUS Check range for marked dates

STRCMP Compare two strings, or part of them. Not case-sensitive.

SUBSTR Extract a substring from an existing Save Array string.

SWITCH Select one of several alternative answers based on condition.

SYMBOL Initialize symbols in the Save Array.

SYMBOLEXIST Verify the existence of a symbol up to current point in survey.

TIME Return current time from clock, other functions.

TOTALINLIST Return total number of options in a select option.

UNMARK Unmark Segments

UNTIL Terminate a loop of questions.

WEEKLYWAGE Calculate a weekly pay rate from another pay rate.

WK2DATE Date Conversion

WRITE Write contents of Save Array location into a file or portion thereof.

XFER Transfer a roster field(s) from or to the Save Array.

ADD YEARS	Add n years to a date
AGE (SINGLE)	Single age calculations
AGE (ARRAY)	Array age calculations
APPEND TO FILE	Append symbol contents to a designated file.
APPEND TO ROSTER	Append records to a roster matching an expression.
BLANK	Blank out one or more sections of the Save Array code.
CHECK	Check for a non-blank character in a string. Opposite of EMPTY.
CLEAN ROSTER	Delete everything in a roster.
CLEANSTRING	Clean and save contents of a symbol or response to a question.
CLONE	Create an exact duplicate of a roster.
CODE	Convert a character string into the corresponding code.
COMBINE	Combine calendar
COMPRESS ROSTER	Compress lines out of a roster if a field is blank.
COPY FILE	Copy from one file name to another. (For example, copy information sheets.)
COUNT	Count number of occurrences of a token in a range of the Save Array.
CREATE	Create new calendar
CREATE DCODE	Create a Pick List record from a file.
CTRLTO	Pass control to a DOS program, Do not return automatically to Windows when finished.
DATE2DAY	Date conversion
DATE2WK	Date conversion
DAY2DATE	Date conversion
DECODE	Convert a code into a corresponding character string.
DELETE DCODE	Delete a Pick List record in the Pick List database.
DELETE FILE	Deletes a file if the file exists.
DELETE LINES FROM ROSTER	Delete rows (records) from a roster.
DIFFAGE	Calculate differences in dates
EMPTY	Check for a blank character in a string in the Save Array.
EXECDOS	Pass control to a DOS program. Do not return automatically to Windows when finished.
EXECWINDOWS	Pass control to a Windows program, wait, return when finished.
EXPAND	Expand multiple Select Option responses in Save Array.
EXPANDDATE	Date expansion
FINDGAPS	Create gap table
FIXDAY	Repair a day in a date
FIXMONTH	Repair a month in a date
FIXYEAR	Repair a year in a date
GET VALUE FROM CODEALL	Get an option selected in a Code All that Apply.
GETSUBDATE	Extract part of a date
INFOSHEET	Create items on an information sheet.
INIT	Initialize calendar
INLIST	Find if an encrypted answer to code all that apply.
INPATH	Check for occurrence of question name(s) in the path.
INSTRING	Check for occurrence of target string in source string.
ISCOMPLETE	Check for a completed date
ISMARKED	Check range for marked dates
LOCATE RECORD	Search external file for a record and copy it contents
MARK	Mark segments
MAX	Find if the maximum number is a range of the Save Array.
MIN	Find if the minimum number is a range of the Save Array.
PRINT	Print a string with substitutions made in it.
READ	Read contents of file or portion thereof into Save Array location.
RECCOUNT	Count the number of records in a roster.
REPEAT	Initiate a loop of questions.
RUN	Runs other FoxPro-based software.
SET LANGUAGE	Set prompt and questionnaire language.
SET NAME	Specify screen display header.
SET ROSTER FIELD VALUE	Set a roster field to a constant value in all rows
SET SEPARATOR	Set date separator, e.g., '-' or '/'.
SET SOUND	Enable or disable the sound.
SORTROSTER	Sort fields in roster by a key.
STATUS	Check range for marked dates
STRCMP	Compare two strings, or part of them. Not case-sensitive.
SUBSTR	Extract a substring from an existing Save Array string.
SWITCH	Select one of several alternative answers based on condition.
SYMBOL	Initialize symbols in the Save Array.
SYMBOLEXIST	Verify the existence of a symbol up to current point in survey.
TIME	Return current time from clock, other functions.
TOTALINLIST	Return total number of options in a select option.
UNMARK	Unmark Segments
UNTIL	Terminate a loop of questions.
WEEKLYWAGE	Calculate a weekly pay rate from another pay rate.
WK2DATE	Date Conversion
WRITE	Write contents of Save Array location into a file or portion thereof.
XFER	Transfer a roster field(s) from or to the Save Array.