I am not sure what I need to do in order to use the STRTOKEN function for my report. The output is PDF.

I would like to retrieve the text from the specialConditions field up to the first period. First I identify which entries retrieved contain the specific text so I use DEFINE to mark them with 1. My next step after I get it to run successfully is retrieve all records flagged with 1.

DEFINE FILE DIRECTDB_CONTRACTSUMMARY_SCHEMA
DUMY/A1 = '';
d_specialConditions/I2=IF SPECIALCONDITIONS CONTAINS 'contracted fares in this term' THEN 1 ELSE 0;
END

TABLE FILE DIRECTDB_CONTRACTSUMMARY_SCHEMA
SUM
DUMY
BY SPECIALCONDITIONS
BY d_specialConditions
WHERE CONTRACTID EQ 24617;
ON TABLE HOLD AS WFHOLD
END

MAINTAIN FILE WFHOLD
MODULE IMPORT (MNTUWS);

TABLE FILE WFHOLD
COMPUTE c_specialConditions/A200 = STRTOKEN(SPECIALCONDITIONS, ".");
END

This message has been edited. Last edited by: Kerry,

I am using the GETTOK function instead and it provides exactly what I need so please disregard.

For reference, you cannot use TABLE FILE inside MAINTAIN.

If you were to use MAINTAIN, then you would have to load a stack and loop through it computing the token, then write the rsult back out to a file.

GETTOK is the right function to use for TABLE FILE to get a token from a string.