Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

Problem description & analysis: There are four strings separated into two parts by vertical bar, namely: ID|DUE_DATE, 80781|2026–12–01, VARCHAR2|DATE, |yyyy-mm-dd. Task: Now we need to generate a four-field result set, extract the first part of each ...