Skip to content

Keyval from CSV support choice of Value separator #213

Open
@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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions