Skip to content

Issue when processing raw_affiliation_string for creating works_authorships in relational database #3

@ZhangWoW123

Description

@ZhangWoW123

When creating the works_authorships table, I noticed some rows are corrupted. By looking at few examples, I noticed that it might be cause by the hidden new line character: \n or \r

Example works 1: https://api.openalex.org/works/W2319247725

Screenshot 2023-09-01 at 1 26 08 AM Screenshot 2023-09-01 at 1 26 54 AM

Example work 2: https://api.openalex.org/works/W2162151071

Screenshot 2023-09-01 at 1 23 57 AM Screenshot 2023-09-01 at 1 27 38 AM

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions