How to Trim values in the graph

shantanu

• April 10, 2008 00:00

• Answered

Follow

Does anyone have example of how to use Trim function in Reformat graph.
i.e
I am trying to read from database and write to a flatfile. Let's say there is only one field "Name", which as trailing space. How can I use trim fucntion to remove all spaces before writing in the flat file.

• 

  avackova

  • April 10, 2008 07:12

  0

  Comment actions Permalink

  function transform(){
  $Name:=trim($Name);
  }
  

  
  or
  

  function transform(){
  $Name:=iif(isnull($Name),null,trim($Name));
  }
  

Please sign in to leave a comment.