Pulling info from 1 data file and printing to another

Hello Everyone,

I would like to pull certain data from one data file and print it to another file ( for back up purposes.)

The first data file is setup like this:
order.db
ID|name|address|company|email
For example i would like to grab the info name and email from order.db and print it to email.db

Any Ideas?

Thanks Wazza
Still learning

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
open file1
read file1
close file1


open file2
loop through file1
match each field with an RE
print $2 and $5 to file2
close file2
[/code]


[This message has been edited by RyanP (edited November 12, 2000).]