UNIX for Dummies Questions & Answers

I am fairly new in unix I was wondering if anybody can help me out with this:

I am trying to output to a file the following fields;

Field1
Field2
Field4

From a database file dataBase1.
this is how the file looks:

dataBase1 TABLE DATA Example
==================


Table
------------------------------------
Field1 : XXXXXXXXXX
Field2 : XXXXXXXXXX
Field3 : XXXXXXXXXX
Field4 : XXXXXXXXX

I am however able to output the fields i wanted one by one by using

*dataBase1_dump -a |grep "Field1 : XXXXX" >filename.out

but I wanted to maybe like output the file in this format

Field1 : XXXXXXXXXX
Field2 : XXXXXXXXXX
Field4 : XXXXXXXXX

Thank You so much for taking the time looking into this guys.

One possible way:

for x in 1 2 4
do
*dataBase1_dump -a | grep "Field$x" >> filename.out
done

Hi,

A solution might be :

>/tmp/output
cat $file | grep -v "pattern from field 3" >>/tmp/output

I think for a better help we might need a little of your log-file. I don't know if you're searching for patterns or not.

Regs David

I believe this is what i was trying to say previously.

I have dataBase1.db
its a database for our subscribers.
Now we have a Tool for dumping this dataBase1 file
already and we are able to dump it into a file.

the file will Look Like this after using

dataBase1_dump -a >file.out <-- dataBase Tool.


dataBase1 TABLE DATA Example
==================


Table SUB
------------------------------------
Subscriber1 : 15DigitNumber
Field1 : 11DigitNumber
Field2 : 11DigitNumber
Field3 : X
Field4 : X
Field5 : 13DigitNumber
Field6 : 13DigitNumber
Field7 : 4DigitNumber
Subscriber2 : 15DigitNumber
Field1 : 11DigitNumber
Field2 : 11DigitNumber
Field3 : X
Field4 : X
Field5 : 13DigitNumber
Field6 : 13DigitNumber
Field7 : 4DigitNumber
Subscriber3 : 15DigitNumber
Field1 : 11DigitNumber
Field2 : 11DigitNumber
Field3 : X
Field4 : X
Field5 : 13DigitNumber
Field6 : 13DigitNumber
Field7 : 4DigitNumber

This will output a file with for now almost 13,000 subscribers.

WHat i need is to output:

( Line1 of output File ) Subscriber1
( Line2 of output File ) Field1 of Subscriber1
( Line3 of output File ) Field2 of Subscriber1
( Line4 of output File ) Field4 of Subscriber1
( Line5 of output File ) Subscriber2
( Line6 of output File ) Field1 of Subscriber2
( Line7 of output File ) Field2 of Subscriber2
( Line8 of output File ) Field4 of Subscriber2
( Line9 of output File ) Subscriber3
( Line10 of output File ) Field1 of Subscriber3
( Line11 of output File ) Field2 of Subscriber3
( Line12 of output File ) Field4 of Subscriber3

Up to subscriber 13,000...

Again Thank You for taking the time looking into this. It will be
a great help to me.