CPI filtering based on text

[mzahmed]

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

[riyazahmed_ca2]

Hi Mohammed,

Try to use right function in the filter.

RIGHT(ZZIBP_ACTUALS_QTY_CI_KF.PROID,5)='_0001'

Best Regards,

Riyaz

[btiruveedula]

Hi Mohammad,

Using the the following condition in 'Filter' tab may work for you. Try it.

if word_ext(ZZIBP_ACTUALS_QTY_CI_KF.PROID,-1,'_') = '0001' then ZZIBP_ACTUALS_QTY_CI_KF.PROID

Refer attached screen (from SAP Help) to understand how the 'word_ext' function works.