This guide will help you learn how to configure the Middle function, which can be used for truncating text strings.

Configuration

Please follow these steps:

1. Configure data sources and provide the mapping
   
   
   
   
2. Drag-and-drop the input and output fields to the work panel of Transform, Join, or Validate node.
   
   
   
   
3. Switch to the Function tab.
4. Press the String button.
5. Drag-and-drop the Middle function icon to the work panel.
6. Map the nodes according to the picture below.
   
   
   
   
7. Double-click on the Middle node.
8. Specify the Begin index (InputStr1) and the End index (InputStr2). The rest of the string will be cropped.
   
   
   
   
9. Click Ok.

Please note that indexing starts from 1.

See also

     Remove Function