Parsing info contained in a single field

I have an input field coming from a .csv that has 3 pieces of data in it separated by periods (.). Example: 1111.2222.33333. Is there a way to parse out the three pieces of information into distinct field outputs in Centerprise?

Yes, a splitstring function transformation can be used to achieve this. You can choose your csv file and provide the string and the separator ("." in this case) to the function and the function transformation will break the string for you in different parts.
You can also go through this article for further details on the topic:

1 Like

You can also set “.” as delimiter in your DelimitedDestination properties.