Delimiting by line break and occurrence splitter question
I'm working on a database import of artworks from FileMaker Pro. The element in question is a list of exhibitions for each artwork, separated by line break.
My first question is whether it's possible to delimit by line break?
If not, I'll just have to go into Excel and do a find and replace.
Furthermore, does anyone have any idea why this refinery isn't producing any occurrences? It's the occurrence splitter on line 10.
Also, my storage location splitter is producing different storage locations, but it's not getting a hierarchy from them. Those cells come in the form of " storage place - shelf - drawer," but there's a lot of variation to make a single hierarchy.