找回密码
 立即注册

扫一扫,访问微社区

QQ登录

只需一步,快速开始

查看: 284|回复: 0

[求助] TXT文档提取相关字段,并保存入Excel中

1

主题

2

帖子

2

积分

贫民

积分
2
chq-saleen 发表于 2019-6-5 10:21:42 | 显示全部楼层 |阅读模式
麻瓜想整理一些Google Schlolar下载的文献资料,保存为TXT格式,现在想把一些字段提取出来保存入Excel中,但是在提取字段中碰到问题,请大家帮忙。
我想提取高亮部分的字段(**),后附要求(绿色)。


PMID- 31131053{PMID号}
OWN - NLM
VI  - 9
IP  - 9
DP  - 2019{年}
TI  - Regulation of ezrin tension by S-nitrosylation mediates non-small cell lung
      cancer invasion and metastasis.

PG  - 2555-2571
LID - 10.7150/thno.32479 [doi]【可能会有两个LID,选择后面有[doi]的】{DOI号}
AB  - Cancer invasion and metastasis depend on accurate and rapid modulation of both
      chemical and mechanical activities. The S-nitrosylation (SNO) of membrane
      cytoskeletal cross-linker protein ezrin may regulate the malignant process in a
      tension-dependent manner. Methods: The level of nitrosylated ezrin in non-small
      cell lung cancer (NSCLC) tissues and A549 cell line were evaluated by
      biotin-switch assay. A few cysteine mutated plasmids of ezrin were used to
      identify active site for SNO. Newly designed ezrin or mutated-ezrin tension
      probes based on Forster resonance energy transfer (FRET) theory were applied to
      visually observe real-time tension changes....
      
摘要}
AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
      University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
FAU - Ruan, Qinli
AU  - Ruan Q
AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
      Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
      210023, Jiangsu, PR China.
AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
      University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
FAU - Wang, Yifan
AU  - Wang Y
AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
      Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
      210023, Jiangsu, PR China.
AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
      University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
FAU - Sun, Lixia
AU  - Sun L
AD  - Affiliated Hospital of Nanjing University of Chinese Medicine, Nanjing 210023,
      Jiangsu, PR China.
FAU - Hu, Yunfeng
AU  - Hu Y
AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
      Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
      210023, Jiangsu, PR China.
AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
      University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
FAU - Zhou, Jingwen
AU  - Zhou J
AD  - The First Clinical Medical College of Nanjing University of Chinese Medicine,
      Nanjing, Jiangsu 210023, PR China.
FAU - Ren, Bin
AU  - Ren B
AD  - Department of Surgery and Biomedical Engineering, University of Alabama at
      Birmingham (UAB), Birmingham, Alabama. 35294, USA.
FAU - Guo, Jun【如果最后一个作者有2个单位,2个单位都要,但是可以放在同一个单元格中】{通讯作者全名(优先选择地址里面有邮箱的,否则就选择最后一个作者)}
AU  - Guo J
AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
      Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
      210023, Jiangsu, PR China.
{通讯作者单位}
AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
      University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
LA  - eng
PT  - Journal Article
DEP - 20190413{发表时间}
PL  - Australia
TA  - Theranostics
JT  - Theranostics{期刊全名}
JID - 101552395
PMC - PMC6525990
OTO - NOTNLM
OT  - FRET
OT  - ezrin S-nitrosylation
OT  - invasion
OT  - metastasis
OT  - non-small cell lung cancer【所有OT,可以放在同一个单元格中】{关键词}
COIS- Competing Interests: The authors have declared that no competing interest exists.
PHST- 2019/05/28 06:00 [medline]
AID - 10.7150/thno.32479 [doi] 【可能会有两个AID,选择后面有[doi]的】{DOI号2}
AID - thnov09p2555 [pii]
PST - epublish
SO  - Theranostics. 2019 Apr 13;9(9):2555-2571. doi: 10.7150/thno.32479. eCollection
      2019.
{引文信息}
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表