I have a string in a cell: A|BCD|EF|GHI|JK.   I would like to extract it separate in individual cells: A should be in one cell, BCD in the next, EF in the next, and so on.   I would appreciate any help on this. Thank you.
79564
I have a column of strings like this:  +---------+ | a bb    | | ccc d   | | ee ffff | +---------+   (exactly one space in each string), which I'd like to split by the space into two columns:   +-----+------+ | a   | bb   | | ccc | d    | | ee  | ffff | +-----+------+   This can be done by putting B1 =split(A1," ") and dragging down the column. But I'm looking for an arrayformula version of this.   Unsuccessful attempt: the formula  =arrayformula(split(A1:A3," ")) throws #VALUE error: "Function SPLIT parameter 1 value should be non-empty."
51028
I'm splitting a string by three different characters but I want the output to include the characters I split by. Is there any easy way to do this?
101232
I have a text file with 9 fields separated by :  survey:m1111771::rent:travel:::Morning:   How do I pull field 1 and 8 only to a separate file  for example it would look like this,  survey:Morning
26213
I can't seem to find an answer to this problem, and I'm wondering if one exists. Simplified example:  Consider a string "nnnn", where I want to find all matches of "nn" - but also those that overlap with each other. So the regex would provide the following 3 matches:   nnnn nnnn nnnn   I realize this is not exactly what regexes are meant for, but walking the string and parsing this manually seems like an awful lot of code, considering that in reality the matches would have to be done using a pattern, not a literal string.
13318
How do I split a string with multiple separators in JavaScript? I'm trying to split on both commas and spaces, but AFAIK JavaScript's split() function only supports one separator.
41680
If I have the following string:  string s = "abcdefghab";   Then how do I get a string (or char[]) that has just the characters that are repeated in the original string using C# and LINQ. In my example I want to end up with "ab".  Although not necessary, I was trying to do this in a single line of LINQ and had so far come up with:  s.ToCharArray().OrderBy(a =&gt; a)...
38733
I want to know if there is an easy way to split a line in a file into multiple lines, such as this:  I have  A B C 1 2 3 4   And I want to get something like this, based on the first string of the line:  A B A C 1 2 1 3 1 4   Basically based on the first string in the line create multiple lines with the second and third and fourth string and so on.
13955
Unless I am missing an obvious built-in method, what is the quickest way to get the nth occurrence of a string within a string?  I realize that I could loop the  method by updating its start index on each iteration of the loop. But doing it this way seems wasteful to me.
38889
What is the best way to tokenize/split a NSString in Objective-C?
18012
I have a single string that contains the command-line parameters to be passed to another executable and I need to extract the string[] containing the individual parameters in the same way that C# would if the commands had been specified on the command-line. The string[] will be used when executing another assemblies entry-point via reflection.  Is there a standard function for this? Or is there a preferred method (regex?) for splitting the parameters correctly? It must handle '"' delimited strings that may contain spaces correctly, so I can't just split on ' '.  Example string:  string parameterString = @"/src:""C:\tmp\Some Folder\Sub Folder"" /users:""abcdefg@hijkl.com"" tasks:""SomeTask,Some Other Task"" -someParam foo";   Example result:  string[] parameterArray = new string[] {    @"/src:C:\tmp\Some Folder\Sub Folder",   @"/users:abcdefg@hijkl.com",   @"tasks:SomeTask,Some Other Task",   @"-someParam",   @"foo" };   I do not need a command-line parsing library, just a way to get the String[] that should be generated.  Update: I had to change the expected result to match what is actually generated by C# (removed the extra "'s in the split strings)
65552
I am no expert with excel so any help is appreciated!   I am trying to make one cell do multiple searches within another.  I know that to search one cell for a specific word you would use  =FIND(Blue,C2)   But I need to find multiple different words in one cell. Heres an example of what im trying to do:    I need to show all the allergens in the ingredients cell eg peanuts, gluten, milk, sesame seeds etc   How do I get the result to list all the allergens?   I know that I can do a single find function in separate cells and then concatenate them, but there must be a more simple way?  Thanks
19725
Consider the following example. If I do \seqsplit{ReferencedIDs} the string does not get split. If on the other hand, I insert the string as an argument directly it does. As usual, I don't know why this isn't working. Can anyone enlighten me?  \documentclass[12pt]{article} \usepackage{seqsplit} \begin{document} \gdef \ReferencedIDs{,2014.11.14,2014.11.14,2014.11.17,2014.11.14,2014.07.18.tm,2014.11.12.tm,2013.10.05.kanjur,2013.10.05.powai,2013.10.06,2013.10.28.zhm,2013.10.17,2013.10.22,2013.10.14.ks,2013.10.06,2013.10.17,2013.10.22,2013.10.24,2013.10.28,2013.10.30,2013.11.11,2014.09.05.tm,2014.07.18.tm,2014.11.12.tm,2014.11.17,2015.01.06,2015.01.06}  \seqsplit{\ReferencedIDs}   \seqsplit{,2014.11.14,2014.11.14,2014.11.17,2014.11.14,2014.07.18.tm,2014.11.12.tm,2013.10.05.kanjur,2013.10.05.powai,2013.10.06,2013.10.28.zhm,2013.10.17,2013.10.22,2013.10.14.ks,2013.10.06,2013.10.17,2013.10.22,2013.10.24,2013.10.28,2013.10.30,2013.11.11,2014.09.05.tm,2014.07.18.tm,2014.11.12.tm,2014.11.17,2015.01.06,2015.01.06}  \end{document}
33592
I have a group of strings in Javascript and I need to write a function that detects if another specific string belongs to this group or not.  What is the fastest way to achieve this? Is it alright to put the group of values into an array, and then write a function that searches through the array?  I think if I keep the values sorted and do a binary search, it should work fast enough. Or is there some other smart way of doing this, which can work faster?
2094
I'm trying to iterate over the words of a string.  The string can be assumed to be composed of words separated by whitespace.  Note that I'm not interested in C string functions or that kind of character manipulation/access. Also, please give precedence to elegance over efficiency in your answer.  The best solution I have right now is:  #include &lt;iostream&gt; #include &lt;sstream&gt; #include &lt;string&gt;  using namespace std;  int main() {     string s = "Somewhere down the road";     istringstream iss(s);      do     {         string subs;         iss &gt;&gt; subs;         cout &lt;&lt; "Substring: " &lt;&lt; subs &lt;&lt; endl;     } while (iss); }   Is there a more elegant way to do this?
6903
In Excel I have two columns, one with about 3000 rows and one with about 100.  I need to find all of the matches between the two columns and put them in a separate column.  I have to do this every morning so if there is a way to do so, I'd like to make it as automated as possible.
4322
I have a long line of code that I want to break up among multiple lines. What do I use and what is the syntax?  For example, adding a bunch of strings,  e = 'a' + 'b' + 'c' + 'd'   and have it in two lines like this:  e = 'a' + 'b' +     'c' + 'd'
10951
I thought this would be really simple, but it's presenting some difficulties. If I have std::string name = &quot;John&quot;; int age = 21;  How do I combine them to get a single string &quot;John21&quot;?