I have this 'sample data' data not in the right form. I need to read this text file and extract the data and tabulate it in the order as shown in figure below. I am not sure how can I do it.
=========== REPORT TEXT ========== RADIOLOGICAL REPORT Patient AAA Date of Birth 17/10/2020 Request Number 2020100000000 RN Number 123456789123 / 123456789 Referring Doctor Examination Date 09/10/2020 MRI - Heart / Cardiac ( Contrast ) Indication blablabla Medication/Contrast blablabla Complications Nil Sequences GRE 2C, 4C, SA - CINE GRE LVOT GRE 2C, 4C, SA - MDE Findings The LV longitudinal and circumferential function is reduced. The right ventricular contractility is normal. The RVOT is normal. No mitral regurgitation. Aortic valve appears normal with 3 cusps seen, mobile and not calcified. No tricuspid regurgitation. No thrombus seen. Mild aortic regurgitation. Normal pericardium. No pericardial effusion. The visualized liver and thoracic spine are normal. Left Ventricular Segments No Wall Motion Perfusion At Rest Perfusion At Stress Delayed Gadolinium Enhancement Basal Anterior 1 Hypokinetic Nil Nil 50% Basal Anteroseptal 2 Dyskinetic Present Present Full thickness Basal Inferoseptal 3 Hypokinetic Present Present 50% Basal Inferior 4 Hypokinetic Nil Present 50% Basal Inferolateral 5 Normal Nil Nil Nil Basal Anterolateral 6 Normal Nil Nil Nil Mid Anterior 7 Hypokinetic Nil Nil <50% Mid Anteroseptal 8 Dyskinetic Present Present Full thickness Mid Inferoseptal 9 Akinetic Present Present Full thickness Mid Inferior 10 Hypokinetic Nil Present <50% Mid Inferolateral 11 Normal Nil Nil Nil Mid Anterolateral 12 Normal Nil Nil <50% Apical Anterior 13 Akinetic Nil Nil 50% Apical Septal 14 Akinetic Nil Nil < 50% Apical Inferior 15 Akinetic Nil Nil > 50% Apical Lateral 16 Hypokinetic Nil Nil Full thickness Apex 17 Akinetic Nil Nil Full thickness LVESV is 138 ml. LVEDV is 172 ml. LVEF is 20 %. The anterior septal wall thickness in is 0.8 cm. (Diastole) The posterior lateral wall thickness is 0.9 cm. (Diastole) Impression 1. Poor LV systolic function. 2. Infarcted and nonviable LAD territory. 3. Some scarring in the RCA territory. However, inferior wall myocardium has to be considered viable. 4. Stress induced ischaemia of RCA territory. 5. Mild AR. Computer generated report. No signature required. ========== REPORT TEXT END =========
Prashant Kumar answered . 2024-05-17 21:36:12
=========== REPORT TEXT ========== RADIOLOGICAL REPORT Patient AAA Date of Birth 17/10/2020 Request Number 2020100000000 RN Number 123456789123 / 123456789 Referring Doctor Examination Date 09/10/2020 MRI - Heart / Cardiac ( Contrast ) Indication blablabla Medication/Contrast blablabla Complications Nil Sequences GRE 2C, 4C, SA - CINE GRE LVOT GRE 2C, 4C, SA - MDE Findings The LV longitudinal and circumferential function is reduced. The right ventricular contractility is normal. The RVOT is normal. No mitral regurgitation. Aortic valve appears normal with 3 cusps seen, mobile and not calcified. No tricuspid regurgitation. No thrombus seen. Mild aortic regurgitation. Normal pericardium. No pericardial effusion. The visualized liver and thoracic spine are normal. Left Ventricular Segments No Wall Motion Perfusion At Rest Perfusion At Stress Delayed Gadolinium Enhancement Basal Anterior 1 Hypokinetic Nil Nil 50% Basal Anteroseptal 2 Dyskinetic Present Present Full thickness Basal Inferoseptal 3 Hypokinetic Present Present 50% Basal Inferior 4 Hypokinetic Nil Present 50% Basal Inferolateral 5 Normal Nil Nil Nil Basal Anterolateral 6 Normal Nil Nil Nil Mid Anterior 7 Hypokinetic Nil Nil <50% Mid Anteroseptal 8 Dyskinetic Present Present Full thickness Mid Inferoseptal 9 Akinetic Present Present Full thickness Mid Inferior 10 Hypokinetic Nil Present <50% Mid Inferolateral 11 Normal Nil Nil Nil Mid Anterolateral 12 Normal Nil Nil <50% Apical Anterior 13 Akinetic Nil Nil 50% Apical Septal 14 Akinetic Nil Nil < 50% Apical Inferior 15 Akinetic Nil Nil > 50% Apical Lateral 16 Hypokinetic Nil Nil Full thickness Apex 17 Akinetic Nil Nil Full thickness LVESV is 138 ml. LVEDV is 172 ml. LVEF is 20 %. The anterior septal wall thickness in is 0.8 cm. (Diastole) The posterior lateral wall thickness is 0.9 cm. (Diastole) Impression 1. Poor LV systolic function. 2. Infarcted and nonviable LAD territory. 3. Some scarring in the RCA territory. However, inferior wall myocardium has to be considered viable. 4. Stress induced ischaemia of RCA territory. 5. Mild AR. Computer generated report. No signature required. ========== REPORT TEXT END =========
str = fileread('sample data.txt');
rgx = ['(Apex|(Basal|Mid|Apical)\s+[A-Z][a-z]+)\s+(\d+)\s+([A-Z][a-z]+)',...
'\s+(Nil|Present)\s+(Nil|Present)\s+(Nil|Full thickness|([<>]\s?)?\d+\%)'];
tkn = regexpi(str,rgx,'tokens');
tkn = vertcat(tkn{:})
Giving:
tkn =
'Basal Anterior' '1' 'Hypokinetic' 'Nil' 'Nil' '50%'
'Basal Anteroseptal' '2' 'Dyskinetic' 'Present' 'Present' 'Full thickness'
'Basal Inferoseptal' '3' 'Hypokinetic' 'Present' 'Present' '50%'
'Basal Inferior' '4' 'Hypokinetic' 'Nil' 'Present' '50%'
'Basal Inferolateral' '5' 'Normal' 'Nil' 'Nil' 'Nil'
'Basal Anterolateral' '6' 'Normal' 'Nil' 'Nil' 'Nil'
'Mid Anterior' '7' 'Hypokinetic' 'Nil' 'Nil' '<50%'
'Mid Anteroseptal' '8' 'Dyskinetic' 'Present' 'Present' 'Full thickness'
'Mid Inferoseptal' '9' 'Akinetic' 'Present' 'Present' 'Full thickness'
'Mid Inferior' '10' 'Hypokinetic' 'Nil' 'Present' '<50%'
'Mid Inferolateral' '11' 'Normal' 'Nil' 'Nil' 'Nil'
'Mid Anterolateral' '12' 'Normal' 'Nil' 'Nil' '<50%'
'Apical Anterior' '13' 'Akinetic' 'Nil' 'Nil' '50%'
'Apical Septal' '14' 'Akinetic' 'Nil' 'Nil' '< 50%'
'Apical Inferior' '15' 'Akinetic' 'Nil' 'Nil' '> 50%'
'Apical Lateral' '16' 'Hypokinetic' 'Nil' 'Nil' 'Full thickness'
'Apex' '17' 'Akinetic' 'Nil' 'Nil' 'Full thickness'
>> size(tkn)
ans =
17 6
>>
Clearly you can put that into a table if you really want to:
>> hdr = {'LeftVentricularSegments','No','WallMotion','PerfusionAtRest','PerfusionAtStress','DelayedGadoliniumEnhancement'};
>> T = cell2table(tkn,'VariableNames',hdr)
T =
LeftVentricularSegments No WallMotion PerfusionAtRest PerfusionAtStress DelayedGadoliniumEnhancement
_______________________ ____ _____________ _______________ _________________ ____________________________
'Basal Anterior' '1' 'Hypokinetic' 'Nil' 'Nil' '50%'
'Basal Anteroseptal' '2' 'Dyskinetic' 'Present' 'Present' 'Full thickness'
'Basal Inferoseptal' '3' 'Hypokinetic' 'Present' 'Present' '50%'
'Basal Inferior' '4' 'Hypokinetic' 'Nil' 'Present' '50%'
'Basal Inferolateral' '5' 'Normal' 'Nil' 'Nil' 'Nil'
'Basal Anterolateral' '6' 'Normal' 'Nil' 'Nil' 'Nil'
'Mid Anterior' '7' 'Hypokinetic' 'Nil' 'Nil' '<50%'
'Mid Anteroseptal' '8' 'Dyskinetic' 'Present' 'Present' 'Full thickness'
'Mid Inferoseptal' '9' 'Akinetic' 'Present' 'Present' 'Full thickness'
'Mid Inferior' '10' 'Hypokinetic' 'Nil' 'Present' '<50%'
'Mid Inferolateral' '11' 'Normal' 'Nil' 'Nil' 'Nil'
'Mid Anterolateral' '12' 'Normal' 'Nil' 'Nil' '<50%'
'Apical Anterior' '13' 'Akinetic' 'Nil' 'Nil' '50%'
'Apical Septal' '14' 'Akinetic' 'Nil' 'Nil' '< 50%'
'Apical Inferior' '15' 'Akinetic' 'Nil' 'Nil' '> 50%'
'Apical Lateral' '16' 'Hypokinetic' 'Nil' 'Nil' 'Full thickness'
'Apex' '17' 'Akinetic' 'Nil' 'Nil' 'Full thickness'
Matlabsolutions.com provides guaranteed satisfaction with a commitment to complete the work within time. Combined with our meticulous work ethics and extensive domain experience, We are the ideal partner for all your homework/assignment needs. We pledge to provide 24*7 support to dissolve all your academic doubts. We are composed of 300+ esteemed Matlab and other experts who have been empanelled after extensive research and quality check.
Matlabsolutions.com provides undivided attention to each Matlab assignment order with a methodical approach to solution. Our network span is not restricted to US, UK and Australia rather extends to countries like Singapore, Canada and UAE. Our Matlab assignment help services include Image Processing Assignments, Electrical Engineering Assignments, Matlab homework help, Matlab Research Paper help, Matlab Simulink help. Get your work done at the best price in industry.
Australia
UK
UAE
Singapore
Canada
New
Zealand
Malaysia
USA
India
South Africa
Ireland
Saudi
Arab
Qatar
Kuwait
Hongkong
Copyright 2016-2023 www.matlabsolutions.com - All Rights Reserved.
Disclaimer : Any type of help and guidance service given by us is just for reference purpose. We never ask any of our clients to submit our solution guide as it is, anywhere.
