Double Quotes in exported file
-
- Posts: 8
- Joined: Tue Oct 10, 2017 12:44 pm
Double Quotes in exported file
I have a client using R&R xBase version 9 to export data from a FoxPro database to text data files. There is one field that is a character data type but routinely contains all numeric characters in it. The export keeps wrapping this value in double quotes which we don^t want it to do. If the field happens to contain even on alpha character then there are no double quotes around the value in the export file.____How can we consistently prevent double quotes around this character field value, and also make sure that it doesn^t implicitly drop lead or trailing zeros?____Thanks
-
- Posts: 47
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: Double Quotes in exported file
If you were pretty sure that it would always contain numeric data, I^d say the easiest thing would be to create a calculation from your field and export that. However, to prevent leading zeroes from being cut off, you would need to select properties for the item, uncheck "show zero" and check "leading zeroes." You^d also need to change the numeric properties to no decimals.____For example, you have a field called ZIPCODE which is a Char(5) field. Create a calculation called ValZIP: Val(ZIPCODE) and replace your ZIPCODE field on the layout with ValZIP.__