regexgoogle-sheetsspreadsheettransposetextjoin
How do I use regex in sheets to number (in cell) everything new line that starts with Letters?
My goal is to get something like this goal. For every new line after the 1st one if it doesn't start with a ">" I want it to be numbered (starting from nr. 1 on), as for the lines that start with ">" - to just return those without numbering them. I've tried to insert strings with the numbers See here, the problem is I don't know how many lines I might have that don't start with ">" and if these are intercalated with the other ones - so I can't really "hardcode" the string into the formula, as I did. Any solutions? thanks.
Solution
try:
=ARRAYFORMULA(TEXTJOIN(CHAR(10), 1, IF(REGEXMATCH(""&
SPLIT(A2, CHAR(10)), "^>.*"),
SPLIT(A2, CHAR(10)), TRANSPOSE(MMULT(TRANSPOSE(TRANSPOSE((SEQUENCE(1, COLUMNS(
SPLIT(A2, CHAR(10))))<=SEQUENCE(COLUMNS(
SPLIT(A2, CHAR(10)))))*NOT(REGEXMATCH(
SPLIT(A2, CHAR(10)), "^>.+")))), TRANSPOSE(SIGN(NOT(REGEXMATCH(
SPLIT(A2, CHAR(10)), "^>.+"))))))&". "&
SPLIT(A2, CHAR(10)))))
- How to combine all the words of a sentence extracted with a regex?
- How can I detect all symbols on mathematical operators on PHP using regex?
- RegEx for combining "match everything" and "negative lookahead"
- How to validate an Instagram username
- Parse video id and start time from differently formatted youtube URL strings
- Python - regex to grab specific lines from text
- how to escape texts for formatting in python
- Regex not correctly rejecting invalid music note values
- regex - error with result - too many occurence
- Parse a formatted, single-line string into an array of associative arrays with predefined column names
- How to split a string by any of multiple delimiters?
- std::regex escape special characters for use in regex
- Does lookbehind work in sed?
- Regex for complex delimited string with multiple parse patterns
- Parsing PDF tables into csv with php
- RegEx for "does not begin with"
- PHP regex starting and ending with < and > produces an unknown modifier warning
- Sanitize number by removing first digit then any consecutive zeros
- How to match one or more characters nominated in a regex character class?
- Sanitize a number which may include dollar symbols, hyphens and dots
- Validate a numeric filename which may only be between 01 and 12, then the file extension
- Regex for number check below a value (12)
- Validate a string containing a number, underscore, then an number with a maximum of 12 digits
- Regular expression that allows only a specific special character when it has a specific length
- java - regex pattern matching days, hours, minutes, seconds
- Regex pattern for matching words between two delimiters
- Matching a String in Python using regex
- How to match and extract string matching regular expression
- Problem subsetting a string from a filename
- Remove all non-alphanumeric characters but keep float values