Import text fields into columns from txt file

**Pshawn** · 01-24-2010, 01:03 PM

Hi,

I have a file from PubMed with a bunch of citations in it, which often go above 10,000 per file. There are fields that mean certain things and I would like to be able to import the text file into Excel and parse certain fields into columns. Could you please help? thanks.

The text file looks like this:

PMID- 19782657
OWN - NLM
STAT- In-Process
DA - 20091109
IS - 1872-6240 (Electronic)
VI - 1303
DP - 2009 Dec 15
TI - Functional near-infrared spectroscopy to investigate hemodynamic responses to
deception in the prefrontal cortex.
PG - 120-30
AB - Deception involves complex neural processes and correlates in the brain.....
AD - Department of Bioengineering, The University of Texas at Arlington, P.O. Box
19138, Arlington, TX 76019-0138, USA.
FAU - Tian, Fenghua
AU - Tian F
FAU - Sharma, Vikrant
AU - Sharma V
FAU - Kozel, F Andrew
AU - Kozel FA
FAU - Liu, Hanli
AU - Liu H
LA - eng
PT - Journal Article
DEP - 20090925
PL - Netherlands
TA - Brain Res
JT - Brain research
JID - 0045503
SB - IM
....

MID- 19931310
OWN - NLM
STAT- Publisher
DA - 20091125
IS - 1872-678X (Electronic)
DP - 2009 Nov 17
TI - Use of fNIRS to assess resting state functional connectivity.
AB - Recently, resting state functional connectivity (RSFC) studies based on ...

and so on.

**JBeaucaire** · 01-24-2010, 01:45 PM

Go ahead make a small version of the text file that represents 3-4 complete "records" to evaluate.

Then make a workbook that demonstrates the column layout and how the data from that sample data set would fall into that layout. Shouldn't take long to mock up, should it?

Then click GO ADVANCED on your next post and use the paperclip icon to post up your sample workbook and sample text file. That should make it absolutely clear what you want to accomplish, yes?

**Pshawn** · 01-24-2010, 02:15 PM

JBeaucaire,

Here are the attachments.

SamplePMC.txt

PMCTemplate.xlsx

Many thanks.

Originally Posted by JBeaucaire

Go ahead make a small version of the text file that represents 3-4 complete "records" to evaluate.

Then make a workbook that demonstrates the column layout and how the data from that sample data set would fall into that layout. Shouldn't take long to mock up, should it?

Then click GO ADVANCED on your next post and use the paperclip icon to post up your sample workbook and sample text file. That should make it absolutely clear what you want to accomplish, yes?

**JBeaucaire** · 01-28-2010, 12:30 PM

Originally Posted by JBeaucaire

Go ahead make a small version of the text file that represents 3-4 complete "records" to evaluate.

Then make a workbook that demonstrates the column layout and how the data from that sample data set would fall into that layout. Shouldn't take long to mock up, should it?

Go ahead and complete the sample workbook. Put the data from the sample txt file into the workbook in the appropriate columns. Believe it or not, I expect you will do at least one thing I wouldn't predict and this makes it absolutely clear what you expect to happen.

For instance, there are many AU values per record, so I'm interested in how you're going to lay that out.