Thanks Karen, for the suggestion.....this did work just fine.
On Monday, February 6, 2023 at 01:36:15 PM EST, 'Karen Tellef' via RBASE-L
<[email protected]> wrote:
I looked in my notes. I see you're exporting to a CSV. If you don't need a
CSV, my notes say that exporting to a worksheet (XLS) rather than a work book
(XLSW) retains leading zeros
Karen
-----Original Message-----
From: 'jim schmitt' via RBASE-L <[email protected]>
To: rbase group <[email protected]>
Sent: Mon, Feb 6, 2023 12:19 pm
Subject: [RBASE-L] - leading zeros and excel gateway file
Hello, Group:
I am transfering a data file using the gateway command, and two of the fields
which are text and have a leading zero ('0602', '0605').When I use the gateway
command, everything is fine, except the two fields with leading zeros in the
csv file have dropped the leading zeros (which are needed).
Am I missing something or can this be resolved. ? gateway command and sample
file attached
Thanks, Jim,
gateway command and sample file attached::
GATEWAY EXPORT CSV w2upload.csv + SELECT * FROM OHIO_W2_DATA + OPTION
COL_NAMES OFF --- | SHOW_PROGRESS ON | ACTION OPENVIEW
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1973250947.972841.1675707561020%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1290823543.771706.1675708572260%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/514754207.1599362.1677517857883%40mail.yahoo.com.
