设为首页收藏本站
切换到窄版

鱼C论坛

 找回密码
 立即注册
鱼C论坛»论坛 › 萌新训练营 › 萌新交流区 › 新手求助，TXT文档提取相关字段，并保存入表格
返回列表 发新帖
查看: 1222|回复: 5

新手求助，TXT文档提取相关字段，并保存入表格

[复制链接]
chq-saleen
发表于 2019-6-4 16:47:28 | 显示全部楼层 |阅读模式

马上注册，结交更多好友，享用更多功能^_^

您需要 登录 才可以下载或查看，没有账号？立即注册

x
本麻瓜想整理一些Google Schlolar下载的文献资料，保存为TXT格式，现在想把一些字段提取出来保存入Excel中，但是在提取字段中碰到问题，请大家帮忙。
我想提取高亮部分的字段（黄色），后附要求（绿色）。


PMID- 31131053{PMID号}
OWN - NLM
STAT- In-Data-Review
LR  - 20190527
IS  - 1838-7640 (Electronic)
IS  - 1838-7640 (Linking)
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. Cytoskeleton depolymerizing and motor
      molecular inhibiting experiments were performed to reveal the alternation of the
      mechanical property of ezrin after SNO. Transwell assays and xenograft mouse
      model were used to assess aggressiveness of A549 cells in different groups.
      Fluorescent staining was also applied to examine cellular location and
      structures. Results: High inducible nitric oxide synthase (iNOS) levels were
      observed to induce ezrin-SNO, and then promote malignant behaviors of NSCLC cells
      both in vitro and in vivo. Cys(117) was identified as the only active site for
      ezrin-SNO. Meanwhile, an increased level of ezrin tension was observed after
      iNOS-induced SNO. Enhanced ezrin tension was positively correlated with
      aggressiveness of NSCLC. Moreover, Microfilament (MF) forces instead of
      microtubule (MT) forces played dominant roles in modulating ezrin tension,
      especially after ezrin nitrosylation. Conclusion: This study revealed a
      SNO-associated mechanism underlying the mechanical tension of ezrin. Ezrin-SNO
      promotes NSCLC cells invasion and metastasis through facilitating mechanical
      transduction from the cytoskeleton to the membrane. These studies implicate the
      therapeutic potential by targeting ezrin in the inhibition NSCLC invasion and
      metastasis. {摘要}
FAU - Zhang, Xiaolong
AU  - Zhang X
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 - Li, Guangming
AU  - Li G
AD  - Department of Anesthesiology, Huaian First People's Hospital, Nanjing Medical
      University, Huaian 223001, Jiangsu, PR China.
FAU - Guo, Yichen
AU  - Guo Y
AD  - Department of Surgery and Biomedical Engineering, University of Alabama at
      Birmingham (UAB), Birmingham, Alabama. 35294, USA.
FAU - Song, Ying
AU  - Song Y
AD  - Department of Respiratory Medicine, The First Affiliated Hospital of Nanjing
      Medical University, Nanjing 210029, PR China.
FAU - Chen, Linlin
AU  - Chen L
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 - 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.
EDAT- 2019/05/28 06:00
MHDA- 2019/05/28 06:00
CRDT- 2019/05/28 06:00
PHST- 2018/12/21 00:00 [received]
PHST- 2019/03/18 00:00 [accepted]
PHST- 2019/05/28 06:00 [entrez]
PHST- 2019/05/28 06:00 [pubmed]
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. {引文信息}
小甲鱼最新课程 -> https://ilovefishc.com
回复

使用道具 举报

wp231957
发表于 2019-6-4 17:21:30 | 显示全部楼层
那么多FAU 都选吗  还是只选你框黄色的部分
小甲鱼最新课程 -> https://ilovefishc.com
回复 支持 反对

使用道具 举报

wp231957
发表于 2019-6-4 18:36:22 | 显示全部楼层

  2. s='''
  3. PMID- 31131053{PMID号}
  4. OWN - NLM
  5. STAT- In-Data-Review
  6. LR  - 20190527
  7. IS  - 1838-7640 (Electronic)
  8. IS  - 1838-7640 (Linking)
  9. VI  - 9
  10. IP  - 9
  11. DP  - 2019{年}
  12. TI  - Regulation of ezrin tension by S-nitrosylation mediates non-small cell lung
  13.        cancer invasion and metastasis.
  14. PG  - 2555-2571
  15. LID - 10.7150/thno.32479 [doi]【可能会有两个LID，选择后面有[doi]的】{DOI号}
  16. AB  - Cancer invasion and metastasis depend on accurate and rapid modulation of both
  17.        chemical and mechanical activities. The S-nitrosylation (SNO) of membrane
  18.        cytoskeletal cross-linker protein ezrin may regulate the malignant process in a
  19.        tension-dependent manner. Methods: The level of nitrosylated ezrin in non-small
  20.        cell lung cancer (NSCLC) tissues and A549 cell line were evaluated by
  21.        biotin-switch assay. A few cysteine mutated plasmids of ezrin were used to
  22.        identify active site for SNO. Newly designed ezrin or mutated-ezrin tension
  23.        probes based on Forster resonance energy transfer (FRET) theory were applied to
  24.        visually observe real-time tension changes. Cytoskeleton depolymerizing and motor
  25.        molecular inhibiting experiments were performed to reveal the alternation of the
  26.        mechanical property of ezrin after SNO. Transwell assays and xenograft mouse
  27.        model were used to assess aggressiveness of A549 cells in different groups.
  28.        Fluorescent staining was also applied to examine cellular location and
  29.        structures. Results: High inducible nitric oxide synthase (iNOS) levels were
  30.        observed to induce ezrin-SNO, and then promote malignant behaviors of NSCLC cells
  31.        both in vitro and in vivo. Cys(117) was identified as the only active site for
  32.        ezrin-SNO. Meanwhile, an increased level of ezrin tension was observed after
  33.        iNOS-induced SNO. Enhanced ezrin tension was positively correlated with
  34.        aggressiveness of NSCLC. Moreover, Microfilament (MF) forces instead of
  35.        microtubule (MT) forces played dominant roles in modulating ezrin tension,
  36.        especially after ezrin nitrosylation. Conclusion: This study revealed a
  37.        SNO-associated mechanism underlying the mechanical tension of ezrin. Ezrin-SNO
  38.        promotes NSCLC cells invasion and metastasis through facilitating mechanical
  39.        transduction from the cytoskeleton to the membrane. These studies implicate the
  40.        therapeutic potential by targeting ezrin in the inhibition NSCLC invasion and
  41.        metastasis. {摘要}
  42. FAU - Zhang, Xiaolong
  43. AU  - Zhang X
  44. AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
  45.        Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
  46.        210023, Jiangsu, PR China.
  47. AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
  48.        University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
  49. FAU - Li, Guangming
  50. AU  - Li G
  51. AD  - Department of Anesthesiology, Huaian First People's Hospital, Nanjing Medical
  52.        University, Huaian 223001, Jiangsu, PR China.
  53. FAU - Guo, Yichen
  54. AU  - Guo Y
  55. AD  - Department of Surgery and Biomedical Engineering, University of Alabama at
  56.        Birmingham (UAB), Birmingham, Alabama. 35294, USA.
  57. FAU - Song, Ying
  58. AU  - Song Y
  59. AD  - Department of Respiratory Medicine, The First Affiliated Hospital of Nanjing
  60.        Medical University, Nanjing 210029, PR China.
  61. FAU - Chen, Linlin
  62. AU  - Chen L
  63. AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
  64.        Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
  65.        210023, Jiangsu, PR China.
  66. AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
  67.        University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
  68. FAU - Ruan, Qinli
  69. AU  - Ruan Q
  70. AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
  71.        Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
  72.        210023, Jiangsu, PR China.
  73. AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
  74.        University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
  75. FAU - Wang, Yifan
  76. AU  - Wang Y
  77. AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
  78.        Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
  79.        210023, Jiangsu, PR China.
  80. AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
  81.        University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
  82. FAU - Sun, Lixia
  83. AU  - Sun L
  84. AD  - Affiliated Hospital of Nanjing University of Chinese Medicine, Nanjing 210023,
  85.        Jiangsu, PR China.
  86. FAU - Hu, Yunfeng
  87. AU  - Hu Y
  88. AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
  89.        Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
  90.        210023, Jiangsu, PR China.
  91. AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
  92.        University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
  93. FAU - Zhou, Jingwen
  94. AU  - Zhou J
  95. AD  - The First Clinical Medical College of Nanjing University of Chinese Medicine,
  96.        Nanjing, Jiangsu 210023, PR China.
  97. FAU - Ren, Bin
  98. AU  - Ren B
  99. AD  - Department of Surgery and Biomedical Engineering, University of Alabama at
  100.        Birmingham (UAB), Birmingham, Alabama. 35294, USA.
  101. FAU - Guo, Jun【如果最后一个作者有2个单位，2个单位都要，但是可以放在同一个单元格中】{通讯作者全名（优先选择地址里面有邮箱的，否则就选择最后一个作者）}
  102. AU  - Guo J
  103. AD  - State Key Laboratory Cultivation Base for TCM Quality and Efficacy, School of
  104.        Medicine and Life Science, Nanjing University of Chinese Medicine, Nanjing
  105.        210023, Jiangsu, PR China. {通讯作者单位}
  106. AD  - Key Laboratory of Drug Target and Drug for Degenerative Disease, Nanjing
  107.        University of Chinese Medicine, Nanjing 210023, Jiangsu, PR China.
  108. LA  - eng
  109. PT  - Journal Article
  110. DEP - 20190413{发表时间}
  111. PL  - Australia
  112. TA  - Theranostics
  113. JT  - Theranostics{期刊全名}
  114. JID - 101552395
  115. PMC - PMC6525990
  116. OTO - NOTNLM
  117. OT  - FRET
  118. OT  - ezrin S-nitrosylation
  119. OT  - invasion
  120. OT  - metastasis
  121. OT  - non-small cell lung cancer【所有OT，可以放在同一个单元格中】{关键词}
  122. COIS- Competing Interests: The authors have declared that no competing interest exists.
  123. EDAT- 2019/05/28 06:00
  124. MHDA- 2019/05/28 06:00
  125. CRDT- 2019/05/28 06:00
  126. PHST- 2018/12/21 00:00 [received]
  127. PHST- 2019/03/18 00:00 [accepted]
  128. PHST- 2019/05/28 06:00 [entrez]
  129. PHST- 2019/05/28 06:00 [pubmed]
  130. PHST- 2019/05/28 06:00 [medline]
  131. AID - 10.7150/thno.32479 [doi] 【可能会有两个AID，选择后面有[doi]的】{DOI号2}
  132. AID - thnov09p2555 [pii]
  133. PST - epublish
  134. SO  - Theranostics. 2019 Apr 13;9(9):2555-2571. doi: 10.7150/thno.32479. eCollection
  135.        2019. {引文信息}
  136. '''

  138. import re

  140. pmid=re.search("PMID- (\d+){",s)
  141. print(pmid.group(1))
  142. dp=re.search("DP\s+- (\d+){",s)
  143. print(dp.group(1))
  144. ti= re.search("TI\s+- ([\sa-zA-Z-\.]+)PG",s,re.M)
  145. print(ti.group(1))
  146. lid=re.search("LID\s+- ([\sa-zA-Z-\.\\0-9]+)\[",s)
  147. print(lid.group(1))
  148. ab=re.search("AB\s+- ([\sa-zA-Z-\.\\0-9\(\),:]+){",s,re.M)
  149. print(ab.group(1))
  150. fau=re.findall("FAU\s+- ([\sa-zA-Z,]+)$",s,re.M)
  151. for x in fau:print(x)
  152. ad= re.search("AD\s+- ([\sa-zA-Z0-9-\.,]+){",s,re.M)
  153. print(ad.group(1))
  154. dep=re.search("DEP - (\d+){",s)
  155. print(dep.group(1))
  156. jt=re.search("JT\s+- ([A-Za-z]+){",s)
  157. print(jt.group(1))
  158. ot=re.findall("OT\s+- ([A-Za-z- ]+)$",s,re.M)
  159. for x in ot:print(x)
  160. ot2=re.search("OT\s+- ([a-z]+\-[a-z]+\s+[a-z]+\s+[a-z]+\s+[a-z]+)",s)
  161. print(ot2.group(1))
  162. aid=re.findall("AID\s+- ([\sa-z0-9\.\/]+)",s)
  163. for x in aid:print(x)
  164. so=re.search("SO\s+- ([\sA-Za-z0-9\.\/:;\(\)-]+)",s,re.M)
  165. print(so.group(1))





复制代码
小甲鱼最新课程 -> https://ilovefishc.com
回复 支持 反对

使用道具 举报

wp231957
发表于 2019-6-4 18:36:56 | 显示全部楼层
e:\>python ex3.py
31131053
2019
Regulation of ezrin tension by S-nitrosylation mediates non-small cell lung
       cancer invasion and metastasis.

10.7150/thno.32479
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. Cytoskeleton depolymerizing and motor
       molecular inhibiting experiments were performed to reveal the alternation of the
       mechanical property of ezrin after SNO. Transwell assays and xenograft mouse
       model were used to assess aggressiveness of A549 cells in different groups.
       Fluorescent staining was also applied to examine cellular location and
       structures. Results: High inducible nitric oxide synthase (iNOS) levels were
       observed to induce ezrin-SNO, and then promote malignant behaviors of NSCLC cells
       both in vitro and in vivo. Cys(117) was identified as the only active site for
       ezrin-SNO. Meanwhile, an increased level of ezrin tension was observed after
       iNOS-induced SNO. Enhanced ezrin tension was positively correlated with
       aggressiveness of NSCLC. Moreover, Microfilament (MF) forces instead of
       microtubule (MT) forces played dominant roles in modulating ezrin tension,
       especially after ezrin nitrosylation. Conclusion: This study revealed a
       SNO-associated mechanism underlying the mechanical tension of ezrin. Ezrin-SNO
       promotes NSCLC cells invasion and metastasis through facilitating mechanical
       transduction from the cytoskeleton to the membrane. These studies implicate the
       therapeutic potential by targeting ezrin in the inhibition NSCLC invasion and
       metastasis.
Zhang, Xiaolong
Li, Guangming
Guo, Yichen
Song, Ying
Chen, Linlin
Ruan, Qinli
Wang, Yifan
Sun, Lixia
Hu, Yunfeng
Zhou, Jingwen
Ren, Bin
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.
20190413
Theranostics
FRET
ezrin S-nitrosylation
invasion
metastasis
non-small cell lung cancer
10.7150/thno.32479
thnov09p2555
Theranostics. 2019 Apr 13;9(9):2555-2571. doi: 10.7150/thno.32479. eCollection
       2019.
小甲鱼最新课程 -> https://ilovefishc.com
回复 支持 反对

使用道具 举报

chq-saleen
 楼主| 发表于 2019-6-5 09:43:02 | 显示全部楼层
wp231957 发表于 2019-6-4 18:36
e:\>python ex3.py
31131053
2019

非常感谢。关于前面你提到的作者,是这样的要求：优先选择地址里面有邮箱的，否则就选择最后一个作者
小甲鱼最新课程 -> https://ilovefishc.com
回复 支持 反对

使用道具 举报

chq-saleen
 楼主| 发表于 2019-6-13 11:20:29 | 显示全部楼层
wp231957 发表于 2019-6-4 18:36
e:\>python ex3.py
31131053
2019

非常感谢。关于前面你提到的作者和地址,是这样的要求：优先选择地址里面有邮箱的地址和作者，否则就选择最后一个地址和作者
小甲鱼最新课程 -> https://ilovefishc.com
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

小黑屋|手机版|Archiver|鱼C工作室 ( 粤ICP备18085999号-1 | 粤公网安备 44051102000585号)

GMT+8, 2025-5-16 18:30

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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