I'm new to using Open Refine. I'm currently using the templating feature to transform data on a spreadsheet into an xml file that is structured according to the PBCore schema.
My question relates to the values of the final output and whether it is possible to remove the quotations ("") in bulk. For example, is it possible to remove the quotation marks from every value (e.g., "cpomcp_001167") within the element pbcoreIdentifier?
The photo I provided shows two rows from the spreadsheet being transformed, but eventually I'll transforming 50+ rows at a time. It would be a painstaking task to have to delete the quotations from every single element in a record.
Is it possible to remove the quotations using Open Refine, or does anyone have experience using other platforms?