Assignment to check partial text

[siowfong_chen]

Hi all,

We are using SRM-MDM. We have a requirement to check for specific text in the Short Text description field and if the text is found, we will update the Special Search term field with some texts. I am wondering whether there is a way to achieve this. I thought I can use the assignment function in Data Manager but I found that I cannot have an operator called Contain. Has anyone done something similar?

Would appreciate any help as this.

Cheers!

SF

[Former Member · Accepted solution]

Hi,

You can use the function FIND(s1, s2[, n3])

where

s1 = Actual String

s2 = String to be searched

n3 = Starting position. By default is 1 if not provided

It returns 0 if the string to be searched is not found else the numeric value depicting the position from where the desired searched string starts.

Regards,

Jitesh Talreja

[Former Member]

Hi,

Can you please update us on your issue.

Regards,

Jitesh Talreja

[siowfong_chen]

Sorry for the late reply. I just got to test it now since I have been away in the last few days. Thanks very much for the pointer, I was able to use the FIND function to fulfill my requirement. Example of the code I use:

IF((FIND(SHORT DESCRIPTION,"FULL STRIP STAPLER")<>0),stapler)

Regards

SF

[former_member198313]

if (is_not_null (field) , ........

+ An