I’m trying to extract New York City borough from a full address field. I want a new custom field that has borough values: Brooklyn, Manhattan, Bronx, etc. I tried doing the following but I’m getting an incomplete expression. I have a user license so I would need to do this in table calculations. Thank you
if(contains(${contact.address}, "Bronx","Bronx") = "Bronx"
OR
contains(${contact.address},"Brooklyn") = "Brooklyn"
OR contains(${contact.address},"Manhattan") = "Manhattan") yes,null)