Our system is running IBM i 7.3 with the latest PTF's and TR's (PTF's and
TR's installed in the last 2 weeks).
Jerry Ven recently asked questions about extracting the numeric values
from a character field to use as a key for joining the file to another
file which has a numeric key.
I believe that someone had suggested using the SQL REGEXP_REPLACE scalar
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.