For any string, there are many transformations that you can apply to it, for example:
- Extracting part of the string
- Removing leading spaces
- Converting to uppercase
PDI offers several ways to do this. It's also common to find more than one step that can be used for the same purpose. The following table summarizes the most common PDI steps used to operate on String fields:
PDI step |
Step description |
Calculator |
With the Calculator step, it is possible to apply several transformations on strings including converting to upper and lowercase and removing special characters. You can also use the Calculator to concatenate two or three strings using the operations A+B and A+B+C respectively. |
String Operations |