Skip to main content
Best practices
0 votes
7 replies
103 views

I am experiencing problems with this section of my formula =LET( args; MAP(SPLIT("11/11"&CHAR(10)&CHAR(10)&"1" ; CHAR(10)&CHAR(10)); LAMBDA(v; TO_TEXT(v)))...
Daniel Bandeira's user avatar
0 votes
1 answer
123 views

tl;dr Ideally, I'd want the following "hello world" is split in "hello" and " world" " world" is split in "" and " world" "hello "...
Enlico's user avatar
  • 30.3k
0 votes
2 answers
184 views

I'm trying to get a relatively simple regex working the way I want it to. I'm trying to split a string into an array but ignoring blank lines. Here's what I've got so far const regExp = /\s*(?:\n|$)\s*...
Doug Antill's user avatar
0 votes
0 answers
51 views

I have a table where the values are written this way in one single row: A, B I want "A, B" to be split into two different rows, along with the other fields of the table. For example: I need ...
Cristina Biagiotti's user avatar
0 votes
4 answers
206 views

My vba excel code is using split funtion from a combo box value. It takes an ID (alias=GG) which is a value right of the 6th hyphen. GG = Split(Sheet1.ComboBox1.Value, "-")(6) example return ...
Dasal Kalubowila's user avatar
2 votes
4 answers
194 views

I am attempting to tokenize clock format strings from TCL in C# program using Regex.Split(). For example %A %B %d %Y or %A_%B sometext %d_%Y I tried a regex split on @"(%[a..zA..z]) but it ...
user1741276's user avatar
-3 votes
1 answer
209 views

I'm trying to iterate through a text file's lines using ranges: auto iter_lines(std::ifstream& file) { auto lines = std::ranges::istream_view<char>(file) | std::views::lazy_split(...
aviad1's user avatar
  • 376
1 vote
1 answer
74 views

I've managed to split the values in a multiple-choice data validation cell into a single column using this formula in Google sheets: =ARRAYFORMULA( QUERY( SPLIT( FLATTEN( ...
Leandro de la Cruz's user avatar
1 vote
1 answer
178 views

Calling -split on an empty string results in an array with one element which is an empty string. I expect it to return a zero-length array or a $Null which is not an array. What am I doing wrong? # ...
john v kumpf's user avatar
1 vote
2 answers
165 views

I have code to get an entry value and read it line by line. I decided to use split, but it's not working! Here is the code: def send_to_all(): userraw = userentry.get(1.0, tk.END) sendmsg = ...
محمد مهدی شیخی's user avatar
0 votes
0 answers
118 views

My customer has the request, that a spool with for example 10 Pages need to be downloaded by separated pages. Let´s say, that the Spool has 10 pages and at every two pages I need to split the Spool ...
Mogera's user avatar
  • 37
8 votes
8 answers
998 views

I'm having trouble with the following in R using dplyr and separate. I have a dataframe like this: x<-c(1,2,12,31,123,2341) df<-data.frame(x) and I'd like to split each digit into its ...
Sointu's user avatar
  • 291
9 votes
1 answer
152 views

Let's say I have a bunch of product strings that could vary slightly in format, e.g.: Super red Megaman T-shirt Super Megaman blue T-shirt Super black Megaman T-shirt Super Megaman T-shirt - ...
Stef Dawson's user avatar
-6 votes
2 answers
118 views

My simple Oracle SQL select statement: select id, my_column from my_table; returns the following output with over 1.000.000 rows in the result set: | id | my_column | | 1 | abc.mno.xyz | | 2 | ...
Ann-Christin Lindras's user avatar
-4 votes
3 answers
132 views

I have a string like s = "<foo> <bar ... <baz.ind> and I need only the contents of the last <...>. In the above case it should be only baz.ind. The below code prints not ...
Red-Cloud's user avatar
  • 452

15 30 50 per page
1
2 3 4 5
1638