Database Transpose Problem

  • Thread starter Thread starter HJF
  • Start date Start date
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!
 
How 'bout an example of the data...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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 (e-mail address removed)
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 (e-mail address removed)
ASJ ASJC&^1306
CLS 16
CCL 87.1.5
DAT 20071031
~
PID 50000444
CPE "Title","Initial","Surname"
ADR "Address Detail"
PYR 2009
EML (e-mail address removed)
ASJ ASJC&^2700
DAT 20071101
 
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
 
Back
Top