Database Transpose Problem

H

HJF

Hi, I have a large file where the data is listed as follows:
Field 1 = Column header
Field 2 = Data

Each record has a URN to start with and is seperated by a delimiter from the
next record below, I just don't know how to transpose the data to a flat
file..?


any help appreciated!
 
J

Jeff Boyce

How 'bout an example of the data...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
H

HJF

Hi, see below for example - '~' is the record delimiter... thanks!

Field Name Field Content
PID 50000043
CPE "Title","Initial","Surname"
ADR "Address Detail"
PYR 2009
EML [email protected]
ASJ ASJC&^2732
CLS 33.10.2
CLS 33.4.1
DAT 20071031
~
PID 50000198
CPE "Title","Initial","Surname"
ADR "Address Detail"
PYR 2008
EML [email protected]
ASJ ASJC&^1306
CLS 16
CCL 87.1.5
DAT 20071031
~
PID 50000444
CPE "Title","Initial","Surname"
ADR "Address Detail"
PYR 2009
EML [email protected]
ASJ ASJC&^2700
DAT 20071101
 
J

Jeff Boyce

You provided an example on multiple lines, but said that the "~" was the
delimiter.

How do you know that the other data breaks where it does? Is there a CRLF
in there too?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top