how to check for spaces

David Paras

• July 25, 2012 15:30

In data mapping to do the following ... when the field equals spaces I want to default to zeros.

    WHEN CONDITION{$varFEIN != ' ' } VALUE=[ substring( $varFEIN,1 ,2 ) ] OTHERWISE VALUE=['00' ]

I can't get this to work. What am I doing wrong?

0

• 

  David Paras

  • July 25, 2012 15:31

  WHEN CONDITION{normalize-space($varFEIN) != ''} VALUE=[ substring( $varFEIN,1 ,2 )  ] OTHERWISE VALUE=['00' ]

  This works

  1

Please sign in to leave a comment.