parse copy.out output as plain text?

I wish to parse out an Ingres data copy (with sql db_name < copy.out
> file; where "copy.out" is generated with "copydb" command). I
wonder could someone advice what's the delimiter and line breaks used
in such Ingres copy
file, so I can write a perl script to convert data into plain text
file?

I see irregular "^A" and spaces but can't match up where the line
breaks should be, or tell what they are. Or the unix terminal is
fooling my eyes

Thanks in advance!

Zhiliang

Hi Zhiliang

You should use the copydb command with a -c switch. This way you
will have an open format file (tab delimited) which is easy to parse.
Read the "command & reference" guide for the copydb command and the
SQL guide (copy statement) for figuring out what the copy.out file
contains (and the text file it builds - especially varchar types
etc..)

Hope this helps.

Gary