googlegoogle sheets
I have tried the function SPLIT with the argument "" and it does not work.
I have a list that is phylogenetic code, so in the source file it's structured like: 10??12103??? etc., and I want to insert it into a Google sheet and split it to line up with some precoded materials for other taxa.
The help says:
SPLIT(string, delimiter, treat_delimiters_individually)
so for text in A1 the function is
=SPLIT(A1,"-&",true)
You can use a quite pragmatic approach to reach your goal.
=ARRAYFORMULA(
SPLIT( // string
REGEXREPLACE(
A1:A4, // text
"[users,<=>compani]", // regular_expression
"" // replacement
),
" ") // delimiter
)
copy/paste
=ARRAYFORMULA(SPLIT(REGEXREPLACE(A1:A4, "[users,<=>compani]",""), " "))
The regular_expression is cleaning up the string, in preparation for the SPLIT. The replacement is simply set to contain an empty string. The result, yields a string that contains one or two values, separated by a white space. The delimiter in the SPLIT is set accordingly and all is put into an ARRAYFORMULA.
Best Answer
SPLIT will work:
Here, SPLIT views the split character (i.e, "?") as the same whether there is 1, or whether there are 500 of them in a row.
Of course, this can be applied to an entire column as well:
Your post shows "?" as the non-numeric characters. However, you may simply have meant that those question marks stand for any of various non-numeric characters. In that case, use this:
...or for the whole column...