Dashboard > APATAR FUNCTION GUIDES > Apatar Function Guides > Right Trim Function
  APATAR FUNCTION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Right Trim Function
Added by Alexander Pipko, last edited by Alex Khizhnyak on Jul 01, 2008  (view change)
Labels: 
(None)

This guide will help you learn how to remove extra blank spaces (if any) from right side of a string using Apatar.

Configuration

To start removing blank spaces with the Right Trim function,

  1. Configure data sources and provide the mapping



  2. Open the Transform node
  3. Switch to the Functions tab
  4. Click on the String section to find the Right Trim icon
  5. Drag-and-drop it to the Transformation's work panel



  6. Switch back to the Inputs tab and map the input and output fields according to the picture below



  7. Press Ok and close the Transformation window

Now the output table will contain the strings without extra blank spaces from the right side of the Column field strings.

See also

     Left Trim Function

     Trim Function

     Pad Right Function

     Pad Left Function


Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators