Address validator in Snaplogic

[satluri]

Hello,

We would like to validate the address field and it is not in consistent format to split using SQL.
Is there any snap that will validate the address and split the data like address1,state,city,country and zip code etc.
Appreciate if I can get any inputs on it.

Thanks
Sudheer

[shankarrao2]

For Validation, You can use Data Validator snap which provide different options for checking the data correctness. You can get more help from below link

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438457/Data+Validator

For splitting the address, i think you have to use the Expression Language like example. Split function.