Forum Discussion
Solved
SOLVED - Split data in dynamic/spill array by delimiter
Greetings everyone, I have a calculation tool for Minecraft items that lists data from minecraft.fandom.com/wiki/Crafting and does various things with that data. I cannot get the queried data to ...
Perhaps you mean something like
=TEXTSPLIT( SUBSTITUTE( TEXTJOIN("@",1, B4# ), CHAR(160)&"or", "@" ), , "@" )
Kendethar FILTERXML may help you. Try-
=TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(B4,CHAR(160) & "or","</s><s>")&"</s></t>","//s"))
See the attached file.
Thanks for the reply! XML is foreign to me so I have no idea how that formula works but it is surely a cleaner approach. Two things now to figure out and I can make it perfect.
1) May you make that spill?
2) Can you move everything else down from the split?
It doesn't matter what order they're in but I was thinking of maybe having a spill range of everything that doesn't have a delimiter and a spill range of everything that does (then I'll use =LET() to combine them later)?
