Exporting data with Input Masks

[talia679]

I have these massive databases I need to export into CSV format ... but when I do that I lose the data that is included via an Input Mask.

Example: The field titled BOX has an Input Mask: "PA"99999 but when I export this table I lose the "PA"

Is there a way to export to CSV & keep this very important information?

 

[ghudson]

When you created the input mask... Did you select the option to "Store" the data with the symbols in the mask?

 

[talia679]

I didn't create it ... it's a database that has been in place for ages here ... so I'm guessing no ... but it's not something any of us here created.