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?
@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:
But make sure to apply it just to the zip code column so it doesn’t change any of your other data.
1 Like
Thanks! I will give that a try!
Great, let me know if it works!
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!
1 Like