Skip to content

Support CSVs with embedded return #10

@magic-lantern

Description

@magic-lantern

I have the following example csv with 4 column and 6 rows that has cells with embedded returns. In my experience, this is very common when working with CSVs that contain text data.

Here's an example CSV file:

Criterion for organ dysfunction,Suggested thresholds,Conditions,Severity
"Venoarterial ECLS, temporary or durable LVAD or RVAD support",NA,None,Severe
Cardiac Arrest,NA,None,Severe
Heart rate (HR),">2SD above normal for age
•→ 0-7 days: HR>180 
•→ >1 week - 1 m: HR>180
•→ >1 m - <1 y: HR>180
•→ >1 y - <6 y: HR>160
•→ 6 y - <13 y: HR>150
•→ 13 y - <18 y: HR>130",If present at the same time as any of the other criteria for CV organ dysfunction,Not graded
Systolic blood pressure (SBP),"More than 2SD below normal for age
•→ 0-7 days: SBP<50 
•→ >1 week - 1 m: SBP<70
•→ >1 m - <1 y: SBP<75
•→ >1 y - <6 y: SBP<75
•→ 6 y - <13 y: SBP<80
•→ 13 y - <18 y: SBP<80",If present at the same time as any of the other criteria for CV organ dysfunction,Not graded
Vasoactive-Inotropic Score,≥5,If present at the same time as any of the other criteria for CV organ dysfunction,Not graded

Instead of having the expected output of 4 column and 6 rows, I get this:

Criterion for organ dysfunction Suggested thresholds Conditions Severity
"Venoarterial ECLS temporary or durable LVAD or RVAD support" NA None
Cardiac Arrest NA None Severe

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions