Macro Text manipulation functions

[Former Member]

Hi Folks,

I want to write a MACRO in DP based on the first character of the planner key. Need to calculate if my planner key is 'H*'. The planner key is three characters as given below.

HGK

H1R

HWK

T1R

T2E

T3W

I need to do a calculation for all the materials whose planner key starts with 'H'.

The logic of the conditon will be like

If (SNP Planner Key = 'H*' ) then

Endif

Is there any way to manipulate text in the macro something like TRIM or extract or is there any other way to achieve this?

Thanks & Regards,

Vasudevan

[Former Member · Accepted solution]

Hi

I will suggest to write a small user exit macro with your requirement and then execute the function. You can easily write you require in user exit macro.

Thanks

Amol

[aparna_ranganathan]

Hi Vasudevan ,

Check if the VALUE_CONTAINED() function can be used to satisfy your requirement. I have not used it before , but it looks like your requirement could be satisfied using this function.

I checked in my test system using wildcard * , but for some reason the wildcard option is not working. Try value_contained in conjunction with MATLOC_C function and check if it works.

Thanks

Aparna