Skip to content

Keyval from CSV support choice of Value separator #213

@will-moore

Description

@will-moore

Currently, if you have a value that contains ; then the value is split on this token and multiple Key:Value pairs are created from the same Key:

vals = row[i].strip().split(';')

However, I wanted to use this script with a csv I downloaded from
https://zenodo.org/record/7308444/files/Davis%20lab%20200%20YFP%20trap%20expression.csv?download=1
which works with images from https://zenodo.org/record/7308444/files/Figures.zip?download=1
(paper at https://rupress.org/jcb/article/222/6/e202205129/214092/Systematic-analysis-of-YFP-traps-reveals-common)

That csv uses commas to separate multiplr values, e.g. "synapse, cytoplasm, plasma membrane".
I manually changed the script to split on ", " and this worked great, but it would be nice to have the option to choose this separator:

Screenshot 2023-11-17 at 12 57 00

cc @Tom-TBT since I think your changes at https://github.com/German-BioImaging/omero-scripts/tree/xtnd_support_kvpairs remove this support for multiple Values?

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