cancel
Showing results for 
Search instead for 
Did you mean: 

Interface Det Condition

Former Member
0 Kudos

Hi

I need to write logic in Interface determination. In source file Code field can have values as AB22 or BC22 or CD22 or MX00. There is no mapping for Code in target system.

Source file

Record

Name

Code

Target File

Record

name

I have two message mapping and interface mappings. I want to check substring code = 22 instead of AB22. The reason in future I may get many fields like this. I want to have generic logic.

Note:I don’t want to have a condition like (/p1:Record/Code = AB22) OR (/p1:MT_Sender/Code = BC22) OR (/p1:MT_Sender/Code = CD22)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Try to put there XSLT substring function.

Peter

Former Member
0 Kudos

Hi Peter,

I am using the sunstring function as below but giving me error has no inbound interface found

/p1:MT_Record[substring(Code,2,4) = 22]

Former Member
0 Kudos

This is definately wrong...

try

substring(/p1:MT_..../Code,2,4)=22

Peter

Former Member
0 Kudos

Hi

this is the condition what i have in Interface Det.

/p1:MT_Sender[substring(/p1:MT_Sender/Code,2,4)=99]

Thanks

Former Member
0 Kudos

Hi

this is the condition what i have in Interface Det.

*

/p1:MT_Sender[substring(/p1:MT_Sender/Code,2,4)=99 ]*

error:

Unable to find inbound interface

Thanks

Former Member
0 Kudos

hi

for some reason it is striking the text. It is closed braket [

Former Member
0 Kudos

smab, I tried it very briefly, and:

In the left side I put: substring(/p1:xxxx/Code,2,4)

then = (equal mark) in Condition Editor

and 22 on the right side in Condition Editor...)

The result in Interface Determination Condition is:

(substring(/p1:xxxx/Code,2,4) = 22)

Do you have it like this?

Peter

Former Member
0 Kudos

Hi,

left operand i have

/p1:MT_Sender[substring(/p1:MT_Sender/Code,2,4)]

op.

=

Right Operand

22

one more condition i have is

left operand i have

/p1:MT_Sender[substring(/p1:MT_Sender/Code,2,4)]

op.

=

Right Operand

00

now depending upon above condition MM1 or MM2 has to pick up.

I think substring function is evaluating false every time.

thanks..

Former Member
0 Kudos

SMAB, do you read my messages?

PUT WHOLE LEFT PART in substring function..

Try it then.

Peter

Former Member
0 Kudos

hi,

you can try with endswith function .

check this url

http://www.w3schools.com/xpath/xpath_functions.asp

sri