The old export.dos command allowed you to cocatenate the items into one
file and translate the attribute/value/sub-value marks during the
export. Can the copy command do that too? I can find no options to
support this.

My goal is to export the file to a dos text file, one item per line
translating the attribute marks to "|" and terminating the item with a
cr/lf character.

Mark

Unless it's a really big file, this is one method I've used on other Pick
variants to get the data into the correct format before moving it out of
Pick.  Set up a DICT item called EXPORT with a correlative that concatenates
all the attributes with your chosen '|' separator.  You can include output
conversions as well if required for dates etc. (as shown on attribute 2
below.

001  S
002  0
003  Export
008  A;0:'|':1:'|':2(D4/):'|':3: ... :'|':n    (where n=last attribute for
export)
009  L
010  80

Then do a SELECT on the file using the EXPORT item and save the resulting
list, which is now your Pick data in the required format.

SELECT filename EXPORT

--

Regards, John

"Pick people do it with variable length"

The copy command under OSFI will translate attribute marks into carriage
returns, but unfortunately will not concatenate items for you.

However, the following may be of some use in a general sense.  Replace
the filenames and delimiters as appropriate.

     open pickfile to f1 else stop 201,pickfile
     open "c:/dosfolder" to f2 else stop 201,"no such dos folder
     exists"
     select f1
     output = ""
     loop
         readnext id else exit
         read rec from f1,id then

             output<-1> = rec
         end
     repeat

     write output on f2,outputID

Of course, this will take a while if you're exporting a ton of data, but
this is pretty much what the old EXPORT program did.  It just had a lot
of stuff about finding the FAT on the floppy and all that.  Export was
never intended to copy data to your hard drives. OSFI is.

That concatenate option might be a good enhancement though...

--
Sincerely,

--
Mark Brown
Manager, Continuing Engineering
Pick Systems, Inc.   USA

"The real art of conversation is not only to say the right thing in the
right place,
 but also to leave unsaid the wrong thing at the moment of temptation."

--
Mark Brown
Manager, Continuing Engineering
Pick Systems, Inc.   USA

"The real art of conversation is not only to say the right thing in the right
place,
 but also to leave unsaid the wrong thing at the moment of temptation."

For now I used the attribut definition here and did a file capture with the
emulator. In this case Procomm worked well. The file only had about 20k items.

Thanks to all. I have another problem I'll present in another message. My
list/sort verbs will not work!

Mark