# Zip Code Format

**URL:** <https://community.parabola.io/t/zip-code-format/832>\
**Category:** Ask a question\
**Created:** [July 18, 2020, 3:31pm UTC](https://community.parabola.io/t/zip-code-format/832 "2020-07-18T15:31:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zach\_Willeford](https://avatars.discourse-cdn.com/v4/letter/z/ce7236/32.png) [@Zach\_Willeford](https://community.parabola.io/u/Zach_Willeford)\
**Post date:** [July 18, 2020, 3:31pm UTC](https://community.parabola.io/t/zip-code-format/832/1 "2020-07-18T15:31:11Z")

</div>

My data contains zip codes which looks like =“77494” on reports. My other number data doesn’t look like this. What can I do to make it just 77494?

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [July 18, 2020, 8:25pm UTC](https://community.parabola.io/t/zip-code-format/832/2 "2020-07-18T20:25:17Z")

</div>

@Zach_Willeford Try using the `Find and replace` step! What you’ll want to do is find any occurrences of " or = in the zip code column and replace the value with nothing (which will just remove it). The settings should look something like this:

 ![Screenshot 2020-07-18 13.23.16](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/73fe7b488ed0356cb4173583b1fe86ec3b78bf8a.png)

But make sure to apply it just to the zip code column so it doesn’t change any of your other data.

---

<div class="post-metadata">

**Author:** ![Zach\_Willeford](https://avatars.discourse-cdn.com/v4/letter/z/ce7236/32.png) [@Zach\_Willeford](https://community.parabola.io/u/Zach_Willeford)\
**Post date:** [July 18, 2020, 8:27pm UTC](https://community.parabola.io/t/zip-code-format/832/3 "2020-07-18T20:27:47Z")

</div>

Thanks! I will give that a try!

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [July 18, 2020, 8:28pm UTC](https://community.parabola.io/t/zip-code-format/832/4 "2020-07-18T20:28:24Z")

</div>

Great, let me know if it works!

---

<div class="post-metadata">

**Author:** ![Zach\_Willeford](https://avatars.discourse-cdn.com/v4/letter/z/ce7236/32.png) [@Zach\_Willeford](https://community.parabola.io/u/Zach_Willeford)\
**Post date:** [July 18, 2020, 8:34pm UTC](https://community.parabola.io/t/zip-code-format/832/5 "2020-07-18T20:34:31Z")

</div>

Well, I had split my data so I could run some as a test. When I uploaded the test data it had corrected itself…so I don’t know what happened there, but if it happens again I will keep you solution in mind.  
Thanks!

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [July 18, 2020, 8:35pm UTC](https://community.parabola.io/t/zip-code-format/832/6 "2020-07-18T20:35:30Z")

</div>

Glad to hear it’s working @Zach_Willeford!