Very Computer

I want to find a universal program which can read a text format table
into a table
in database. The format of the text table is not very normal. For
example:

IMSIS            M                   NA  ANRES

20205            5-3094              4   OBA-30
                                         BO-30
                                         MAPVER-1
                                         CBA-30
                                         CBAZ-30
4600000012       5-86139             4   OBA-25
                                         BO-25
                                         OWNMS
                                         NATMS
                                         MAPVER-2
                                         CBA-86
                                         CBAZ-86
                                         CAMEL-2

There OBA,OWNMS are also fields of the table in database.

Best Regards,
Chuan He

Seems like a job for an *awk* script (at least the disecting of the orig.
text file). If you are not very familiar with awk, I would suggest to have
a look at the IBM developer zone for Linux:
http://www-106.ibm.com/developerworks/linux/
There are a lot of articles written by "Daniel Robbins" and esp. one is
titled something like "Common threads: Programming with awk". In this
article (series) he uses an simillar setup as an example.

HTH. Salut, J?rg

--
J?rg Schmitz-Linneweber
gpg/pgp key id: 0x146428F1
ASTON GmbH, Ruhrorter Stra?e 9, 46049 Oberhausen, Germany
Tel. +49 (208) 6201930, FAX +49 (208) 6201950,
http://www.aston-technologie.de

        In Article 128335 of comp.unix.programmer, Joerg Schmitz-Linneweber

        It would be very helpful if you would give more details
about the format of your input file, e.g. what is used as the
field separator, line separator, and what database format you
want to import into.  awk is a likely candidate for such a task
but we cannot assist you because you haven't provided adequate
information:

  1.  What databse tool is being used and what is the
      input format it expects?

  2.  You indicate OBA and OWNMS are fields of the databse but
      what is expected of them?

  3.  Provide examples of not only the input but also the output.

In addition to the link posted, you could also try posting to
comp.lang.awk.  Be sure when you post to include the above
indicated information otherwise you may not get any answers or
the answers will be requesting more inforamtion.

                                        Dave