regexif-statementgoogle-sheetslambdaextract
Extract First chracter of all words except the first one
I have list of names and i am tryign to extract the First word then First character of 2nd word and 3rd character of 3rd work and so on...
I was only able to make this formula but it works till 2nd name how to achieve further any help will be much appreciated.
=LEFT(D4,FIND(" ",D4)-1)&" "&LEFT(LEFT(D4,SEARCH(" ",D4)-1),1)
[enter link description here][2]
[2]:
Solution
try:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(B2:B, "\w+ ")&
BYROW(B2:B, LAMBDA(x, TEXTJOIN(, 1, IFNA(REGEXEXTRACT(
SPLIT(REGEXREPLACE(x, "^(\w+) ", ), " "), "[A-Z]"))))))
update:
=ARRAYFORMULA(IFNA(TRIM(REGEXEXTRACT(B2:B, "\w+")&" "&
BYROW(B2:B, LAMBDA(x, TEXTJOIN(, 1, IFERROR(REGEXEXTRACT(
SPLIT(REGEXREPLACE(x&" ", "^(\w+) ", ), " "), "[A-Z]"))))))))
- Regex: Substitute pattern in string multiple times without leftovers
- How to automate a simple regex-find and replace
- validate the credit card expiry date using java?
- Excessively long text breaks preg_replace()
- Python RegExp global flag
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Regex to validate password strength
- Detect and parse a time range in a format like "2-4pm" for Amazon Lex scheduling bot
- What is the meaning of the Regular Expression ^(.)\1+$
- How to find and replace with regex in excel
- Issue with Regex Pattern (split string with characters & numbers)
- Java 21 Regex Word-boundary matcher Unicode change
- How to get the first Tamil letter in a word?
- The method of using Regular Expression to express Date and Time: YYYY-MM-DD HH:MM:SS.XXX
- Using disjunction (OR) in a lookbehind
- See if a string contains any characters in it
- Multibyte trim in PHP?
- match only the last instance of a pattern with Javascript regexp
- Regex to detect negative numbers but not hyphenated numbers
- How to Fix regular expression capturing group error Bigquery?
- Improving the below RegEx for US and UK Names
- R quanteda kwic not matching negative look behind pattern
- How to know which numbers after . are non trailing zeros
- Help with drivers license number validation regex
- Regex for matching grey colors in hexadecimal notation
- Extract email address from string
- Regex for ISO 8601 durations
- How to find second match in sql
- Regular expression to remove HTML tags
- Matching any number of tokens in any order