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

Configuration

To start removing blank spaces with the Left Trim function,

1. Configure data sources and provide the mapping
   
   
   
   In this example, we will use the following table as a source:
   
   
   
   
2. Open the Transform node
3. Switch to the Functions tab
4. Click on the String section to find the Left Trim icon
5. Drag-and-drop it to the Transformation's work panel
   
   
   
   
6. 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 spacing from the left side of the Column field strings.

Preview

To preview the results, right-click on the output node and select "Preview Results". The following window will pop up:

           

Close the window and continue data integration.

See also

     Right Trim Function

     Trim Function

     Pad Right Function

     Pad Left Function