Graphical Mapping Query

[Former Member]

Hi,

Hopefully a simple question which will have a simple answer! I need to truncate the first two characters from a field on the Outbound side ie:

<OBfield1>AB1234</OBfield1> maps to <INfield1>1234</INfield1>

This is easily done using a substring on OBfield during the mapping. The problem I have is if OBfield is ever NULL i.e.

<OBfield1></OBfield1>

In these cases the mapping fails as the substring operation has no input field.

Question: How can I use Graphical Mapping functions to check for a NULL/Empty node before applying the substring function?

[Former Member · Accepted solution]

I can answer my own question!

/thread/3218162

Excellent example of exactly what I needed to do in that thread.

You can ignore this question!

[former_member184789]

You can simply have a Standard length function, eg if length of source field is greater than 6, then subtsring else pass as it is..