CSV File Leading Zeros

C

CBKowitz

We transfer data to some of our clients with 'CSV' file. The problem that we
have is retaining the leading zero(s) for the SSN field. For example if the
ssn is 011111111, when they import it the leading zero is dropped. We've
tried putting double quotes around the field, but that did not help.

How do we write out the field so that the leading zero is retained when the
file is imported?

Thanks for your help.
 
D

Douglas J. Steele

You're obviously importing the field into a numeric field, not a text field.
Change to text, and you'll keep the leading zeroes.
 
J

John Nurick

Hi,

If the leading zeros appear in the CSV files you are sending them
there's nothing more you can do at your end. The problem is with your
clients' software or the way they are using it.
 
C

CBKowitz

Thanks.

That's what I figured. I just wanted make sure that there wasn't something
that I could do differently.
 
Top