Is there a way to create a column from data in another column? or to convert the result of a formula to text? i.e. I have one column of zips...some are zip and some are zip+4. I can create a formula in another column to standardize, but don't want to duplicate all the data. Any thoughts?
Thanks,
J
Comments
You can use a calculated short answer field and our mid() function to retrieve just the first five digits from your zip code field and insert this in another field. The formula for this would be mid(Zip Code,1,5) and you can read about this and other formulas in the Help. Then you can click on the pencil icon next to this calculated field to convert it to a short answer on the Edit Database screen and remove the original fields.