Double Quotes in exported file

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Dave_(Guest)
Posts: 8
Joined: Tue Oct 10, 2017 12:44 pm

Double Quotes in exported file

Post by Dave_(Guest) » Wed Mar 04, 2009 3:37 pm

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

Chris_Strasser_(Guest)
Posts: 47
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Double Quotes in exported file

Post by Chris_Strasser_(Guest) » Tue Mar 10, 2009 10:30 am

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.__

Post Reply