This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Address validator in Snaplogic

satluri
New Contributor

โ€Ž08-31-2018 02:03 PM

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

0 Kudos
1 REPLY 1

shankarrao2
Employee
Employee

โ€Ž09-03-2018 11:11 PM

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.

0 Kudos