Copies portions of a string into one or more text variables.
UNSTRING {{src_txt_lit|_var|_col}|{src_date_var|_col}}
BY {delim_txt_lit|_var|_col}
INTO dst_txt_var...{src_txt_lit|_var|_col}|{src_date_var|_col}
Characters used to delimit the fields in {src_txt_lit|_var|_col}|{src_date_var|_col}
Destination fields to receive the results.
Each substring is located using the specified delimiter. The source string must not be included in the list of destination strings.
If more destination strings than substrings are found in the source strings, the extra destination strings are each set to an empty string.
If more substrings are found in the source string than in the destination strings, the extra substrings are not processed. It is up to the programmer to ensure that enough destination strings are specified.
If the source is a date variable or column, it is converted to a string according to the following rules:
For DATETIME columns and Production Reporting DATE variables, Production Reporting uses the format specified by SQR_DB_DATE_FORMAT. If not set, Production Reporting uses the first database-dependent format in Table 61, Default Formats by Database.
For DATE columns, Production Reporting uses the format specified by SQR_DB_DATE_ONLY_FORMAT. If not set, Production Reporting uses the format in Table 62, DATE Column Formats.
For TIME columns, Production Reporting uses the format specified by SQR_DB_TIME_ONLY_FORMAT. If not set, Production Reporting uses the format in Table 63, TIME Column Formats.
unstring $show-info by ' - ' into $name $city $state $zip unstring $cust-data by ',' into $cust_num $entry-date $total
The substr and instr functions in Table 52, Miscellaneous Functions underLET