Export in *nix for use in DOS (was Re: Unix import of a DOS spreadsheet...)
Bruce Easton
bruce at stn.com
Wed Sep 8 09:49:54 PDT 2010
(just changing subject for those looking for export - told you i
wasn't awake yet..)
On 9/8/10 12:29 PM, Bruce Easton wrote:
> Without getting nit-pickety about who expressed/quoted something
> poorly, let me clear up the error in the STN's Developer's Reference. I
> believe that the syntax for using 10&13 together as an argument for one
> of the export flags is invalid. I believe there was discussion about
> this here on the forum. I tried it as the record delimiter long ago and
> found it to not work. I've always formatted export files from *nix that
> are intended for Windows using one of the following methods:
>
> 1a. For a one-time job - I just vi the file and add Ctrl-M's to the
> ends of the lines using an ed command within vi:
>
> g:/$/s/$/[ctrl-M]/g
>
> (where "[ctrl-M]" is obtained by doing a Ctrl-V, then Ctrl-M)
> (then just save the file)
>
> or
>
> 1b. If you're sending the file to the Windows system with ftp, port the
> file in ascii mode to the Windows system - it should get the Ctrl-M's
> added to the line endings by whatever you are using to do the ftp.
>
> 2. For something that needs to be embedded in a program for regular usage:
>
> use sed (there have been examples of this here not that long ago I
> think - maybe someone can provide a good example - I have one somewhere
> - I just can't remember and I haven't had my Sudafed and only half my
> espresso yet today)
>
> There are some applications that require another ctrl character to be at
> the end of csv files - I forget which char. - as an end of file marker.
> So if no one tells you about them, then they can cause a bit of grief
> until you realize that you have to add/strip that last char as part of a
> process.
>
>
> Bruce
>
>
> Bruce Easton
> STN, Inc.
>
>
>
>
>
>
> On 9/8/10 11:28 AM, Mike Schwartz wrote:
>>> 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
>>
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
More information about the Filepro-list
mailing list