Skip to Content
avatar image
Former Member

Graphical Mapping Query

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 15, 2013 at 03:11 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2013 at 03:24 PM

    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..

    Add comment
    10|10000 characters needed characters exceeded