Mandatory filed starts with Special Character

[Former Member]

Hello All

Request your help in mapping. I am using SAP PI 7.3

I have source field "ID" with 1.1 occurrence. if ID starts with "?" or any other special character then the entire message should fail in SAP PI 7.3

Example: ID == ?_Example,  then entire message should fail. else the value in the ID field should be passed

can we achieve it through graphical mapping? if not can somebody share the UDF for the same.

Regards

James

[engswee · Accepted solution]

Hi James

You can throw an exception in a UDF. Example below of the source code.

if (input.startsWith("?")){
  throw new RuntimeException("Enter Exception Text");
} else {
  return input;
}

Rgds

Eng Swee

[AntonioSanz]

Hello,

perhaps you can try to use a "if whitout else" clause in message mapping and "startswith" and "not", and use it for mapping the first node of the result message.

So if it starts with "?" the mapping will return an empty message and in your integration scenario it will launch an exception and will not follow.

Regards.

[Former Member]

Thank you Eng Swee for speedy reply

[engswee]

Hi James

Just to add, if you need to handle other special characters as well, you can use the following for your IF condition. It uses Regex to check if the first character is non-alphanumeric

if (input.substring(0,1).matches("\\W")){

You can check what \W with the regex reference below.

Rgds

Eng Swee