Hello,
We’re trying to make a Zap that takes the Lead Location (Which includes STATE, COUNTRY) and have it only output the STATE to our CRM.
As of now, the Zap we have will filter out the COUNTRY correctly, except for when “Washington, D.C.” is the input. The Zap will filter out “D.C.” and the CRM will only display “Washington” as the Lead Location.
How can I make an exception within the Zap so that Every U.S. state can be corectly filtered without also incorrectly filtering out “D.C.” for when “Washington D.C.” is the input?