Extract specific column from a text file

November 2, 2015 at 23:48:44
Specs: Windows 7
I need to extract specific column with information example EudraCT Number: 2006-005473-21 here : is delimiter
and if there is no value after ":" then it should be updated with null example A.8 EMA Decision number of Paediatric Investigation Plan:
then A.,A.1... these values should be eliminated
****************
EudraCT Number: 2006-005473-21
Sponsor's Protocol Code Number: CVALK2303E1
National Competent Authority: UK - MHRA
Clinical Trial Type: EEA CTA
Trial Status: Ongoing
Date on which this record was first entered in the EudraCT database: 2007-03-09
Link: https://www.clinicaltrialsregister....
A. Protocol Information
A.1 Member State Concerned: UK - MHRA
A.2 EudraCT number: 2006-005473-21
A.3 Full title of the trial: An open label extentsion study to evaluate safety, tolerability, and efficacy of 18 weeks of valsartan treatment in children 1-5 years old with hypertension.
A.4.1 Sponsor's protocol code number: CVALK2303E1
A.7 Trial is part of a Paediatric Investigation Plan: Information not present in EudraCT
A.8 EMA Decision number of Paediatric Investigation Plan:
B. Sponsor Information
Sponsor 1
B.1.1 Name of Sponsor: Novartis Pharma Services AG
B.1.3.4 Country: Switzerland
B.3.1 and B.3.2 Status of the sponsor: Commercial
B.4 Source(s) of Monetary or Material Support for the clinical trial:
B.4.1 Name of organisation providing support:
*************
Expected output is
EudraCT Number: 2006-005473-21
Clinical Trial Type: EEA CTA
Trial Status: Ongoing
Member State Concerned: UK - MHRA
EMA Decision number of Paediatric Investigation Plan: null
Name of organisation providing support: null

See More: Extract specific column from a text file

Report •

#1
November 3, 2015 at 06:41:52
im facing it tuff and need urgent help....
the above mentioned source data which i get is multiple files so consider that and write a script
thanks in advance

Report •
Related Solutions


Ask Question