Returns an extracted character value.
| Valid in: | DATA step, PROC SQL, and SCL |
| Restriction: | Always use the DQEXTTOKENGET function to retrieve tokens from extracted values. To extract tokens from values that do not contain delimiters, use the DQTOKEN function. |
| Requirement: | If specified, the locale must be loaded into memory as part of the locale list. |
the value that is extracted according to the specified extraction definition. The value must be the name of a character variable, or a character value in quotation marks. Also valid, an expression that evaluates to a variable name or quoted value.
the name of the extraction definition. The definition must exist in the locale that is used.
specifies a character constant, variable, or expression that contains the locale name.
| Default | The first locale in the locale list. If no value is specified, the default locale is used. |
extValue=dqExtract('Mr. James Joseph Westly', 'NAME', 'ENUSA');
prefix=dqExtTokenGet(extValue, 'Name Prefix', 'NAME', 'ENUSA');
given=dqExtTokenGet(extValue, 'Given Name', 'NAME', 'ENUSA');