Skip to Content
0
Dec 11, 2020 at 01:09 PM

CPI filtering based on text

139 Views Last edit Jan 29, 2021 at 07:17 PM 2 rev

Hi Experts,

We are trying to filter products that have ending with 0001, as only those are required. This field is populated in the source extractor like so (Material_0001, Material_0002), we have tried some filter options to try and extract the required materials that end with 0001 but unfortunately at runtime receive this error:

System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped. Call stack:

Last attempt was trying to create a filter with the logic below , with same error outcome as above

substr(ZZIBP_ACTUALS_QTY_CI_KF.PROID,length(ZZIBP_ACTUALS_QTY_CI_KF.PRDID),4) = '_0001'

Any ideas will be extremely welcome and appreciated.

Regards,

Mohammad