How to: |
The STRTOKEN function returns a substring, consisting of the characters of a string, from the beginning of a string to a specified character, called a delimiter.
To use this function, you must import the function library MNTUWS. For more information on importing this library see Calling a Function.
STRTOKEN(string, delimiters)
where:
Alphanumeric
Is the character string, or a variable that contains the string enclosed in double quotation marks (").
Alphanumeric
Is a character string, or variable enclosed in double quotation marks (") that contains a list of delimiters. Separate the delimiters with semicolons.
STRTOKEN returns a substring of the first five STREET values in the VIDEOTRK data source based on the delimiters period, space, or asterisk.
MAINTAIN FILE VIDEOTRK MODULE IMPORT (MNTUWS); FOR ALL NEXT CUSTID INTO CSTACK ; COMPUTE CNT/I5 = 1; TYPE " "; REPEAT WHILE CNT LE 5; COMPUTE SUBSTREET/A20 = STRTOKEN(CSTACK(CNT).STREET,".; ,*"); TYPE " STREET = <CSTACK(CNT).STREET" TYPE " SUBSTREET = <SUBSTREET " COMPUTE CNT = CNT +1; ENDREPEAT END
The output is:
STREET = 86 ELLIOTT AVE. SUBSTREET = 86 STREET = 7 DAVENPORT LA. SUBSTREET = 7 STREET = 8 MAGNOLIA LA. SUBSTREET = 8 STREET = 35 POWELL ST. SUBSTREET = 35 STREET = 10 COW LA. SUBSTREET = 10