I am trying to import data from text documents I obtain from medlines into an excel spreadsheet. I want about 30 or more columns of information with each line of the spreadsheet reflecting the data from one article.
the document consists of data about articles generated by the medline search.
Each article generated by a search has many data items identified in the result.
Each data item is preceded by a unique identifier consisting of two capital letters and a dash.
however, not every article has identical data items. for instance, "AU -" precedes the author's name. Some articles have one author, but many have four or five author.
Each author is identified by a notation of "AU - " before his or her name. The articles have one such line per author. Some articles may have no author and some may have 20 authors, and hence twenty such lines.
I need a macro to import the data into columns in a spreadsheet.
Here is an example of the data:
HELP!!!!
Lee Tilson
Detroit, MIchigan
_________________________________________
UI - 22569202
PMID- 12681881
OWN - nlm
STAT- completed
DA - 20030408
DCOM- 20030424
IS - 0029-7844
VI - 101
IP - 4
DP - 2003 Apr
TI - Reduced medicolegal risk by compliance with obstetric clinical pathways: a
case--control study.
PG - 751-5
AB - OBJECTIVE: To estimate whether guideline compliance affected medicolegal
risk in obstetrics and whether malpractice claims data can provide useful
information on guideline noncompliance by focusing on the claims
experience of a large health system delivering approximately 12000 infants
annually. METHODS: We retrospectively identified 290 delivery-related
(diagnosis-related groups 370-374) malpractice claims and 262 control
deliveries at the health system during the period from 1988 to 1998.
Clinical pathways for vaginal and cesarean delivery implemented in 1998
were used as a "standard of care." We compared rates of noncompliance with
the pathways in the claims and control groups, calculated an odds ratio
for increased risk of being sued given departure from the guideline
standards, and calculated the elevated risk of litigation introduced by
noncompliance. We also compared the frequencies of different types of
departures across claims and control groups. RESULTS: Claims closely
resembled controls on several descriptive measures (mother's age, location
of delivery, type of delivery, and complication rates), but noncompliance
with the clinical pathway was significantly more common among claims than
controls (43.2% versus 11.7%, P <.001; odds ratio = 5.76, 95% confidence
interval 3.59, 9.2). In 81 (79.4%) of the claims involving noncompliance
with the pathway, the main allegation in the claim related directly to the
departure from the pathway. The excess malpractice risk attributable to
noncompliance explained approximately one third (104 of 290) of the claims
filed (attributable risk = 82.6%). There were no significant differences
in the types of deviation from the guidelines across claims and control
groups. CONCLUSION: In addition to reducing clinical variation and
improving clinical quality of care, adherence to clinical pathways might
protect clinicians and institutions against malpractice litigation.
Malpractice data might also be a useful resource in understanding
breakdowns in processes of care.
AD - Department of Obstetrics and Gynecology, Wayne State University School of
Medicine, Bloomfield Hills, Michigan 48301, USA. sransom@med.wayne.edu
FAU - Ransom, Scott B
AU - Ransom SB
FAU - Studdert, David M
AU - Studdert DM
FAU - Dombrowski, Mitchell P
AU - Dombrowski MP
FAU - Mello, Michelle M
AU - Mello MM
FAU - Brennan, Troyen A
AU - Brennan TA
LA - eng
GR - K02HS11285/HS/AHCPR
PT - Journal Article
PT - Multicenter Study
PL - United States
TA - Obstet Gynecol
JID - 0401101
SB - AIM
SB - IM
MH - Adult
MH - Case-Control Studies
MH - Critical Pathways/*standards
MH - Delivery, Obstetric/legislation & jurisprudence/*standards
MH - Diagnosis-Related Groups/statistics & numerical data
MH - Female
MH - *Guideline Adherence
MH - Hospitals, Maternity
MH - Human
MH - Insurance Claim Review
MH - Malpractice/*legislation & jurisprudence/statistics & numerical data
MH - Michigan
MH - Obstetrics/legislation & jurisprudence/*standards
MH - Practice Guidelines/*standards
MH - Pregnancy
MH - Retrospective Studies
MH - Risk Assessment
MH - Support, Non-U.S. Gov't
MH - Support, U.S. Gov't, P.H.S.
EDAT- 2003/04/12 05:00
MHDA- 2003/04/25 05:00
AID - S0029784402031290 [pii]
PST - ppublish
SO - Obstet Gynecol 2003 Apr;101(4):751-5.
UI - 22535220
PMID- 12649246
OWN - nlm
STAT- completed
DA - 20030321
DCOM- 20030409
IS - 1468-5833
VI - 326
IP - 7390
DP - 2003 Mar 22
TI - Improving the doctor-manager relationship. Doctors and managers: mind the
gap.
PG - 652-3
AD - Office of Health Policy and Clinical Outcomes, Jefferson Medical College,
1015 Walnut Street, Suite 115 Curtis, Philadelphia, PA 19107, USA.
David.nash@mail.tju.edu
FAU - Nash, David B
AU - Nash DB
LA - eng
PT - Journal Article
PL - England
TA - BMJ
JID - 8900488
SB - AIM
SB - IM
MH - Attitude of Health Personnel
MH - Education, Medical
MH - Health Care Reform/*organization & administration
MH - Hospital Administrators/education/*organization & administration
MH - *Hospital-Physician Relations
MH - Human
MH - *Interprofessional Relations
MH - Medical Staff, Hospital/*organization & administration
MH - Quality Assurance, Health Care
MH - United States
EDAT- 2003/03/22 04:00
MHDA- 2003/04/10 05:00
AID - 10.1136/bmj.326.7390.652/a [doi]
AID - 326/7390/652/a [pii]
PST - ppublish
SO - BMJ 2003 Mar 22;326(7390):652-3.
UI - 22535829
PMID- 12648317
OWN - nlm
STAT- completed
DA - 20030321
DCOM- 20030417
IS - 1064-7449
VI - 10
IP - 4
DP - 2002
TI - Compliance with a protocol for intrapartum antibiotic prophylaxis against
neonatal group B streptococcal sepsis in women with clinical risk factors.
PG - 223-9
AB - OBJECTIVE: The aim of this study was to determine the prevalence of
clinical risk factors (CRF) for neonatal sepsis in laboring women and to
evaluate clinician compliance with a CRF-based protocol for intrapartum
antibiotic prophylaxis (IAP). METHODS: A retrospective chart audit was
undertaken at a district hospital (A) and a tertiary obstetric hospital
(B) in Sydney, Australia between 1996 and 1998, to determine compliance
with IAP in women with defined CRF. RESULTS: Eighty-five (12%) women at
Hospital A and 117 (19%) at Hospital B had one or more CRF. Overall
compliance rates with the IAP protocols were 65 and 50% at Hospitals A and
B respectively, but varied according to maternal, obstetric and
sepsis-related risk factors. We postulate that differences between the
hospitals were related to protocol implementation. CONCLUSIONS: Compliance
with a CRF-based protocol was lower than previously reported. Improvements
in protocol development, implementation and maintenance are required to
enhance compliance with IAP based on CRF.
AD - Department of Public Health, University of Sydney, Australia.
TSanders@csdgp.com.au
FAU - Sanders, Toni R
AU - Sanders TR
FAU - Roberts, Christine L
AU - Roberts CL
FAU - Gilbert, Gwendolyn L
AU - Gilbert GL
LA - eng
PT - Journal Article
PL - United States
TA - Infect Dis Obstet Gynecol
JID - 9318481
SB - IM
MH - Adult
MH - Antibiotic Prophylaxis/*standards
MH - Delivery, Obstetric
MH - Female
MH - Gestational Age
MH - Guideline Adherence/*statistics & numerical data
MH - Hospitals, Community/standards
MH - Hospitals, Maternity/standards
MH - Human
MH - Infant, Newborn
MH - Labor, Obstetric
MH - Medical Records
MH - New South Wales/epidemiology
MH - Pregnancy
MH - Pregnancy Complications, Infectious/epidemiology/*prevention & control
MH - Prevalence
MH - Retrospective Studies
MH - Risk Factors
MH - Sepsis/epidemiology/*prevention & control
MH - Streptococcal Infections/epidemiology/*prevention & control
MH - Streptococcus agalactiae/isolation & purification
MH - Support, Non-U.S. Gov't
EDAT- 2003/03/22 04:00
MHDA- 2003/04/18 05:00
PST - ppublish
SO - Infect Dis Obstet Gynecol 2002;10(4):223-9.
UI - 22528061
PMID- 12640812
OWN - nlm
STAT- completed
DA - 20030318
DCOM- 20030404
IS - 1096-6293
VI - 11
IP - 2
DP - 2003 Feb
TI - Reducing malpractice exposure.
PG - 20
AD - Clarke Silverglate Campbell Williams & Montgomery, Miami, USA.
FAU - Ramos, Francisco Jr
AU - Ramos F Jr
LA - eng
PT - Journal Article
PL - United States
TA - Adv Nurse Pract
JID - 9892010
SB - N
MH - Documentation/standards
MH - Human
MH - Malpractice/*legislation & jurisprudence
MH - Nurse Practitioners/education/*legislation & jurisprudence/psychology
MH - Nurse-Patient Relations
MH - Professional Autonomy
MH - Risk Management/*organization & administration
MH - United States
EDAT- 2003/03/19 04:00
MHDA- 2003/04/05 05:00
PST - ppublish
SO - Adv Nurse Pract 2003 Feb;11(2):20.
the document consists of data about articles generated by the medline search.
Each article generated by a search has many data items identified in the result.
Each data item is preceded by a unique identifier consisting of two capital letters and a dash.
however, not every article has identical data items. for instance, "AU -" precedes the author's name. Some articles have one author, but many have four or five author.
Each author is identified by a notation of "AU - " before his or her name. The articles have one such line per author. Some articles may have no author and some may have 20 authors, and hence twenty such lines.
I need a macro to import the data into columns in a spreadsheet.
Here is an example of the data:
HELP!!!!
Lee Tilson
Detroit, MIchigan
_________________________________________
UI - 22569202
PMID- 12681881
OWN - nlm
STAT- completed
DA - 20030408
DCOM- 20030424
IS - 0029-7844
VI - 101
IP - 4
DP - 2003 Apr
TI - Reduced medicolegal risk by compliance with obstetric clinical pathways: a
case--control study.
PG - 751-5
AB - OBJECTIVE: To estimate whether guideline compliance affected medicolegal
risk in obstetrics and whether malpractice claims data can provide useful
information on guideline noncompliance by focusing on the claims
experience of a large health system delivering approximately 12000 infants
annually. METHODS: We retrospectively identified 290 delivery-related
(diagnosis-related groups 370-374) malpractice claims and 262 control
deliveries at the health system during the period from 1988 to 1998.
Clinical pathways for vaginal and cesarean delivery implemented in 1998
were used as a "standard of care." We compared rates of noncompliance with
the pathways in the claims and control groups, calculated an odds ratio
for increased risk of being sued given departure from the guideline
standards, and calculated the elevated risk of litigation introduced by
noncompliance. We also compared the frequencies of different types of
departures across claims and control groups. RESULTS: Claims closely
resembled controls on several descriptive measures (mother's age, location
of delivery, type of delivery, and complication rates), but noncompliance
with the clinical pathway was significantly more common among claims than
controls (43.2% versus 11.7%, P <.001; odds ratio = 5.76, 95% confidence
interval 3.59, 9.2). In 81 (79.4%) of the claims involving noncompliance
with the pathway, the main allegation in the claim related directly to the
departure from the pathway. The excess malpractice risk attributable to
noncompliance explained approximately one third (104 of 290) of the claims
filed (attributable risk = 82.6%). There were no significant differences
in the types of deviation from the guidelines across claims and control
groups. CONCLUSION: In addition to reducing clinical variation and
improving clinical quality of care, adherence to clinical pathways might
protect clinicians and institutions against malpractice litigation.
Malpractice data might also be a useful resource in understanding
breakdowns in processes of care.
AD - Department of Obstetrics and Gynecology, Wayne State University School of
Medicine, Bloomfield Hills, Michigan 48301, USA. sransom@med.wayne.edu
FAU - Ransom, Scott B
AU - Ransom SB
FAU - Studdert, David M
AU - Studdert DM
FAU - Dombrowski, Mitchell P
AU - Dombrowski MP
FAU - Mello, Michelle M
AU - Mello MM
FAU - Brennan, Troyen A
AU - Brennan TA
LA - eng
GR - K02HS11285/HS/AHCPR
PT - Journal Article
PT - Multicenter Study
PL - United States
TA - Obstet Gynecol
JID - 0401101
SB - AIM
SB - IM
MH - Adult
MH - Case-Control Studies
MH - Critical Pathways/*standards
MH - Delivery, Obstetric/legislation & jurisprudence/*standards
MH - Diagnosis-Related Groups/statistics & numerical data
MH - Female
MH - *Guideline Adherence
MH - Hospitals, Maternity
MH - Human
MH - Insurance Claim Review
MH - Malpractice/*legislation & jurisprudence/statistics & numerical data
MH - Michigan
MH - Obstetrics/legislation & jurisprudence/*standards
MH - Practice Guidelines/*standards
MH - Pregnancy
MH - Retrospective Studies
MH - Risk Assessment
MH - Support, Non-U.S. Gov't
MH - Support, U.S. Gov't, P.H.S.
EDAT- 2003/04/12 05:00
MHDA- 2003/04/25 05:00
AID - S0029784402031290 [pii]
PST - ppublish
SO - Obstet Gynecol 2003 Apr;101(4):751-5.
UI - 22535220
PMID- 12649246
OWN - nlm
STAT- completed
DA - 20030321
DCOM- 20030409
IS - 1468-5833
VI - 326
IP - 7390
DP - 2003 Mar 22
TI - Improving the doctor-manager relationship. Doctors and managers: mind the
gap.
PG - 652-3
AD - Office of Health Policy and Clinical Outcomes, Jefferson Medical College,
1015 Walnut Street, Suite 115 Curtis, Philadelphia, PA 19107, USA.
David.nash@mail.tju.edu
FAU - Nash, David B
AU - Nash DB
LA - eng
PT - Journal Article
PL - England
TA - BMJ
JID - 8900488
SB - AIM
SB - IM
MH - Attitude of Health Personnel
MH - Education, Medical
MH - Health Care Reform/*organization & administration
MH - Hospital Administrators/education/*organization & administration
MH - *Hospital-Physician Relations
MH - Human
MH - *Interprofessional Relations
MH - Medical Staff, Hospital/*organization & administration
MH - Quality Assurance, Health Care
MH - United States
EDAT- 2003/03/22 04:00
MHDA- 2003/04/10 05:00
AID - 10.1136/bmj.326.7390.652/a [doi]
AID - 326/7390/652/a [pii]
PST - ppublish
SO - BMJ 2003 Mar 22;326(7390):652-3.
UI - 22535829
PMID- 12648317
OWN - nlm
STAT- completed
DA - 20030321
DCOM- 20030417
IS - 1064-7449
VI - 10
IP - 4
DP - 2002
TI - Compliance with a protocol for intrapartum antibiotic prophylaxis against
neonatal group B streptococcal sepsis in women with clinical risk factors.
PG - 223-9
AB - OBJECTIVE: The aim of this study was to determine the prevalence of
clinical risk factors (CRF) for neonatal sepsis in laboring women and to
evaluate clinician compliance with a CRF-based protocol for intrapartum
antibiotic prophylaxis (IAP). METHODS: A retrospective chart audit was
undertaken at a district hospital (A) and a tertiary obstetric hospital
(B) in Sydney, Australia between 1996 and 1998, to determine compliance
with IAP in women with defined CRF. RESULTS: Eighty-five (12%) women at
Hospital A and 117 (19%) at Hospital B had one or more CRF. Overall
compliance rates with the IAP protocols were 65 and 50% at Hospitals A and
B respectively, but varied according to maternal, obstetric and
sepsis-related risk factors. We postulate that differences between the
hospitals were related to protocol implementation. CONCLUSIONS: Compliance
with a CRF-based protocol was lower than previously reported. Improvements
in protocol development, implementation and maintenance are required to
enhance compliance with IAP based on CRF.
AD - Department of Public Health, University of Sydney, Australia.
TSanders@csdgp.com.au
FAU - Sanders, Toni R
AU - Sanders TR
FAU - Roberts, Christine L
AU - Roberts CL
FAU - Gilbert, Gwendolyn L
AU - Gilbert GL
LA - eng
PT - Journal Article
PL - United States
TA - Infect Dis Obstet Gynecol
JID - 9318481
SB - IM
MH - Adult
MH - Antibiotic Prophylaxis/*standards
MH - Delivery, Obstetric
MH - Female
MH - Gestational Age
MH - Guideline Adherence/*statistics & numerical data
MH - Hospitals, Community/standards
MH - Hospitals, Maternity/standards
MH - Human
MH - Infant, Newborn
MH - Labor, Obstetric
MH - Medical Records
MH - New South Wales/epidemiology
MH - Pregnancy
MH - Pregnancy Complications, Infectious/epidemiology/*prevention & control
MH - Prevalence
MH - Retrospective Studies
MH - Risk Factors
MH - Sepsis/epidemiology/*prevention & control
MH - Streptococcal Infections/epidemiology/*prevention & control
MH - Streptococcus agalactiae/isolation & purification
MH - Support, Non-U.S. Gov't
EDAT- 2003/03/22 04:00
MHDA- 2003/04/18 05:00
PST - ppublish
SO - Infect Dis Obstet Gynecol 2002;10(4):223-9.
UI - 22528061
PMID- 12640812
OWN - nlm
STAT- completed
DA - 20030318
DCOM- 20030404
IS - 1096-6293
VI - 11
IP - 2
DP - 2003 Feb
TI - Reducing malpractice exposure.
PG - 20
AD - Clarke Silverglate Campbell Williams & Montgomery, Miami, USA.
FAU - Ramos, Francisco Jr
AU - Ramos F Jr
LA - eng
PT - Journal Article
PL - United States
TA - Adv Nurse Pract
JID - 9892010
SB - N
MH - Documentation/standards
MH - Human
MH - Malpractice/*legislation & jurisprudence
MH - Nurse Practitioners/education/*legislation & jurisprudence/psychology
MH - Nurse-Patient Relations
MH - Professional Autonomy
MH - Risk Management/*organization & administration
MH - United States
EDAT- 2003/03/19 04:00
MHDA- 2003/04/05 05:00
PST - ppublish
SO - Adv Nurse Pract 2003 Feb;11(2):20.
