no
> Sent: 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&qu
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 kin
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
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:
Sent: Monday, January 16, 2006 10
@listserver.u2ug.org
Subject: [U2] CSVs' (Different Question)
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 when the c
] CSVs' (Different Question)
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 when the csv is opened in Excel.
I will
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 this,
LINE=LOCAL
LINE<2>="=":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 ze
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 when the csv is opened in Excel.
I will save everyone the trouble with pr