Unix import of a DOS spreadsheet...
Mike Schwartz
mschw at athenet.net
Wed Sep 8 08:28:28 PDT 2010
> Reference filePro Developers Reference 4th edition page 369 secs
> 25.09.04 & 25.10.02
>
> Where Stuart mentioned n=10&13 was for a record separator when
> "CREATING" a
> file on a Unix system for use in Windows not for import.
>
> Richard
Maybe you have hit the nail on the head, and that the r=10&13 syntax
only works when exporting a file, not importing a file, although the book
doesn't make that distinction.
In 25.09.06, where you are looking at this n=10&13 syntax, I think
Stuart meant to write: \n=10&13.
I'll have to test this on an export command later, when I have the
time.
I was reading just a little above that in 25.09.02 (Codes for record
and field separators and delimiters) where it states "The decimal equivalent
of any ASCII character may be used." He goes on to say, "If you wish 2
characters, join them with an ampersand (&). They are not enclosed in quotes
or parentheses - just stated numerically." That paragraph doesn't
explicitly mention that it works only on exporting and not for importing.
By using an xlate command, I completed the accounting file import that
I was trying to use this syntax with, so I'm going to live with the issue
for the time being...
I would add this 2-digit record delimiter idea to the filePro "wish
list", if that still exists, but I'm sure Ken has much bigger fish to fry...
Thanks!
Mike Schwartz
More information about the Filepro-list
mailing list