jbreslow Posted November 28, 2001 Share Posted November 28, 2001 How do I keep the leading zeros on an export from FM 4.1? The field name is called "mail_code", it is a text field not a numeric field and there isn't any calculations going on. Basically this is what the data is in the "mail_code" field: 0234 0061 0432 0003 0893 etc... what I get: 234 61 432 3 893 HELP!! Josh Link to comment Share on other sites More sharing options...
Vaughan Posted November 28, 2001 Share Posted November 28, 2001 I'd suggest double-checking the it isn't a number field. How are you exporting -- tab delimited or something else? Link to comment Share on other sites More sharing options...
jbreslow Posted November 28, 2001 Author Share Posted November 28, 2001 I am positive it isn't a date or number field. I have tried exporting CSV, TAB, CSV, DBF and MER. I have also tried all of the character formats, Windows, DOS, Mac and Lotus. Link to comment Share on other sites More sharing options...
Kurt Knippel Posted November 29, 2001 Share Posted November 29, 2001 I am positive it isn't a date or number field. Link to comment Share on other sites More sharing options...
jbreslow Posted November 29, 2001 Author Share Posted November 29, 2001 Yes I am "Positive" and yes I did go over to the actual machine t check. Why would I lie to ya? Link to comment Share on other sites More sharing options...
BobWeaver Posted November 29, 2001 Share Posted November 29, 2001 What software are you using to open and look at the exported file? In other words, are you sure that it isn't the target application that is stripping the leading zeroes? Link to comment Share on other sites More sharing options...
d94dsj Posted December 8, 2001 Share Posted December 8, 2001 quote: Originally posted by BobWeaver: What software are you using to open and look at the exported file? In other words, are you sure that it isn't the target application that is stripping the leading zeroes? Bob has a good point. For example, the standard behaviour of Excel 97, is to strip off leading zeroes, if you "drag" the file into Excel. If you import it with the File->Open command in Excel, you must change the default data type value of the column containing the values. I don't remember what it is called, sorry... /Daniel Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8174 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now