Try this,
LINE=LOCAL
LINE2==:QUOTE(REP.ID)
CONVERT @AM TO ',' IN LINE
Subject: Exporting leading zero fields in csv.
I have been exporting from MV to CSV for years and one of my pet peeves
is
that leading zero fields, like customer numbers, product codes and zip
codes
lose their leading zeros
To get Excel to keep the leading zeroes when importing a CSV, quote
the value, aka:
=012345
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Try making it an html file and write it out with a .xls file extension.
Excel will be quite happy to open it
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson
Sent: Sunday, January 15, 2006 7:54 AM
To: u2-users@listserver.u2ug.org
Subject: [U2]
You can do an HTML document but save it with the .XLS extension and EXCEL
will open it by default.
Thanks,
David A. Green
DAG Consulting
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Sunday, January 15, 2006 7:54 AM
To:
Where do I quote these?
I have MV basic programs that create csv's, ie
A,B,C,12345,000123
already.
Thanks.
- Original Message -
From: Kevin King [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, January 16, 2006 10:08 AM
Subject: RE: [U2] CSVs' (Different Question
Mark Johnson wrote:
Where do I quote these?
A,B,C,12345,000123
The info I posted about single quotes in my last post wasn't helpful in
this context. Let me try this way:
A,B,12,34,Hi World
Excel doesn't need quotes unless you're doing something special, which
explains why the A and B values
Thank you Tony for a great expose on CSV. Well stated, especially
this part:
There are no formal standards which govern how CSV files work. There
are generally accepted conventions, but of course these aren't all
followed by Excel. Using the guidelines above you can experiment with
certain
: Tuesday, 17 January 2006 11:38 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] CSVs' (Different Question)
Mark Johnson wrote:
Where do I quote these?
A,B,C,12345,000123
The info I posted about single quotes in my last post wasn't helpful in
this context. Let me try this way:
A,B