Pipe-delimited cell values, but need to Add Columns From Other Project

[mcyzyk]

Whatever the solution, it's going to involve forEach() and cross()! I LUV Openrefine.

Found these, major Clues:

Hints, Tips and Tricks

I thought it might be fun and interesting to post some OpenRefine hint/tip/tricks. I’m going to try to post one every week on a Friday - at least for as long as I can keep it going… so here goes with my first one: The GREL length() function can be used to check the length of an array. It’s surprisingly useful in a wide variety of scenarios. For example: value.find("string").length() or value.find(/regular expression/).length() can be used in a custom text facet to see how often a particular…

Combine Specific Parts of Two Spreadsheets

Hello, I would appreciate some help trying to combine parts of two spreadsheets that contain many different values, but one standard value that could be used as a key. I will provide two links. One to the spreadsheet that contains the current metadata: And to another that contains the “keys” which is where I want the values from the previous sheet to me moved to: As you can see. The “key” is that the “Identifier ID” columns from both sheets match up in certain places, and I would like for…

So good!