Monthly Archives: June 2019

With this example AMDP script special characters gets sorted out using regular expressions: outTab = SELECT “/BIC/A”, “/BIC/B”, REPLACE_REGEXPR(‘([^[:print:]|^[\x{00C0}-\x{017F}]|[#])’ IN “/BIC/C” WITH ” OCCURRENCE ALL ) AS “/BIC/C”, “/BIC/D”, “RECORD”, “SQL__PROCEDURE__SOURCE__RECORD” FROM :inTab; The expression filters everything non printable or … Continue reading →

To do a alpha conversion directly in AMDP script the following expression can be used: SELECT …, CASE WHEN ( LENGTH(LTRIM(hanaview.”CHARACTERISTIC”,’ 0123456789′)) = 0 and LTRIM(hanaview.”CHARACTERISTIC”,’ ‘) <> ” ) THEN LPAD( hanaview.”CHARACTERISTIC”,5,’0’ ) ELSE hanaview.”CHARACTERISTIC” END as “/BIC/CHARACTERISTIC”, … … Continue reading →