I'm several transforms into a project and realized there's an escaping issue with my CSV, so some rows are being split where they shouldn't and the following columns are shifted to the right. I'm assuming that editing the original file won't help. Should I export my current project, fix the faulty rows and start a new one? I could join them, but then is there a way to shift values to the left? Thanks!
Welcome to the forum! I would follow the approach you laid out (exporting the project history, applying whatever processing needs to happen, and then recreating the project and reapplying the history). I can’t think of what issues might come up if you edit the underlying data directly without changing the project first, but it feels like it’d be altogether safer to export the project first.
Hi @Rory, thanks!
I hadn't thought of (didn't know it was possible to) exporting the history. I just considered getting a snapshot of the data until this point, then 'starting over’.
But I'm curious, does OpenRefine keep reading the source data or once I start a project it loads it into its own memory? Like, if I go and edit a cell in Excel, should I see it reflected in OpenRefine?
No. Once the source data has been read into OpenRefine the original data source (whether that’s a file or some other source like a URL or database) isn’t used again. OpenRefine stores data in its own project format which is where any changes etc are stored.
2 Likes