All things TrackVia!

Read, write, comment.

This is a public Category  publicRSS

Product Question

    Copy data from a column
    Product Question posted 10/23/09 by Jason
    334 Views, 1 Comment
    Question:
    Copy data from a column
    Answer:

    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

    • posted 10/23/09 by Matt Strenz

      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.