Field Breakup

[DW]

Hello - I have a table that contains a description field.
I want to create a query that will break the description
field into multiple fields. The table also contains
another field that states the number of lines the
description field contains. Here is an example

NUM_OF_DESCRIPTION_LINES = 5

DESCRIPTION = SELIGMAN CASH MANAGEMENT FUND CLASS
C 4986739 5 - FRAC.5900

It seems as if the fields are separated by tabs. Can
anyone help me with this? Thanks in Advance.
DW

 

[John Vinson]

Hello - I have a table that contains a description field.
I want to create a query that will break the description
field into multiple fields. The table also contains
another field that states the number of lines the
description field contains. Here is an example

NUM_OF_DESCRIPTION_LINES = 5

DESCRIPTION = SELIGMAN CASH MANAGEMENT FUND CLASS
C 4986739 5 - FRAC.5900

It seems as if the fields are separated by tabs. Can
anyone help me with this? Thanks in Advance.
DW

Are the five lines *five separate records*? If so is there anything in
the record which would tie them together? Are the labels "DESCRIPTION"
and "MANAGEMENT FUND" and "CLASS" fieldnames, and do the fieldnames
vary from record to record? This could be a nightmarishly difficult
project if so!

If you're getting this data from an external Text file, you may have
better luck using the Text Import utility, but I fear you'll need some
VBA code to break it up.