Address Cleanse Generating NULLS

[system]

Hey guys,
So if I try to address cleanse a record that has “O’Fallon” as the city, the transform outputs NULLS for everything. However, if the city is “O Fallon”, the transform spits out addresses correctly. I need some advice on how to fix this.

Thanks,
Daniel Hosler

---

DanHosler (BOB member since 2013-06-19)

[system]

the obvious solution is to strip punctuation. (make sure to strip ms smart quotes) :x

this will standardize with a valid postcode.

after staring at bad addresses the last 6 years… the cleanup never ends.

---

jlynn73 (BOB member since 2009-10-27)

[system]

Wow. Can’t believe I didn’t think of that. I guess I was trying too hard to find a problem with the address cleanse transform. Thanks. Is there a function to strip all punctuation, or should I keep using replace_substr?

---

DanHosler (BOB member since 2013-06-19)