24,568 questions
Best practices
0 votes
7 replies
103 views
SPLIT without implicit conversion
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)))...
0 votes
1 answer
123 views
What's the idiomatic/correct way to split a string into its first word and the rest of the string? [closed]
tl;dr Ideally, I'd want the following "hello world" is split in "hello" and " world" " world" is split in "" and " world" "hello "...
0 votes
2 answers
184 views
Split a string into an array but ignoring blank lines [duplicate]
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*...
0 votes
0 answers
51 views
How to split one row with column = "A, B" into two rows with "A" and "B"
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 ...
0 votes
4 answers
206 views
Split function with if statement to define string value (excel vba)
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 ...
2 votes
4 answers
194 views
Regex to split on %[A..Za..z]
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 ...
-3 votes
1 answer
209 views
Splitting file content using C++20 ranges [closed]
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(...
1 vote
1 answer
74 views
Google Sheets, Trim function not removing leading space
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( ...
1 vote
1 answer
178 views
`-split` of an empty string results in an array with one element which is an empty string
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? # ...
1 vote
2 answers
165 views
Splitting text by new line: "NameError: name 'split' is not defined" [duplicate]
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 = ...
0 votes
0 answers
118 views
Splitting Spool by pages and download in ABAP
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 ...
8 votes
8 answers
998 views
How can I split a vector of numbers into its digits when vector values differ in length?
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 ...
9 votes
1 answer
152 views
How to remove character differences from multiple strings [duplicate]
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 - ...
-6 votes
2 answers
118 views
Reverse order of split string parts [closed]
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 | ...
-4 votes
3 answers
132 views
Get string between two delimiters
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 ...