ODI Text to columns
Looking for a text to columns function within ODI
Hello, We're migrating from Alteryx to ODI. The Alteryx tool has a very straight forward "Text to Columns" function that allows a user to take the contents of one column, and split it into multiple columns based on a specified delimiter. See Alteryx Documentation here - https://help.alteryx.com/2020.2/TextToColumns.htm
What is the equivalent function/transformation in ODI? If there isn't a built in function like this, what is the best way to handle this very common operation? Is there any documentation about how to perform this operation?