database - What is the best way to validate and parse complex fields in Pentaho kettle? -

What is the best way to validate a field in a row and if it is invalid, then correct it in the correct form?

The easiest example can come in the phone number field (version format -> 111-111-1111, (111) 111-1111 etc.), and ideally we validate them and standardized one form Want to say (lets say: 1111111111). One way to do this is to use the filter rows and then use regex, or we can use the data validator. But it will only tell us which data is invalid but it is not actually formatted for us. We can use the javascript revised value step to write a JSP script for this. But I'm guessing that there is a better way (or has been built in the integration I have not come), who will do these basic assumptions or?

After