filtersplitgoogle-sheets-formulamatchdelimited
Extract nth element from comma-delimited list with Google Sheets formula
I have a string:
"apple12,bear23,chile,dormir45,elephant"
I'd like to use the regexextract() formula to get the nth element from this list, where n is going to be a row() in an arrayformula. I just need the regex where I can input a number {1}, {2}, {3}, etc.
Workbook to help: https://docs.google.com/spreadsheets/d/1zAf41twr_JCkZ44Qo5j73WrWhXDc2KoOo3UI4RpyUI8/edit?usp=sharing
I realize this is probably possible with =SUBSTRING() as well.
Solution
use:
=INDEX(SPLIT(A1, ","),, B2)
where B2 is value with position
- Filters Not Functioning for Admin Application Logs in Google Admin SDK
- React warning: A component is changing an uncontrolled input to be controlled in `react-data-table-component-with-filter`
- how to use inequality filter in pivotby formula on aggregated values, not table data
- Drop duplicates using pandas groupby
- AutoFilter returning to 1st Range when trying to apply filter to different Range
- WordPress query_posts with multiple tax_query
- ffmpeg using an expression for tile filter
- Filter out Down-candles to only include Up-candles in calculations in Pine Script
- Filter with expression expansion
- Is there any reason to use css box-shadow over drop-shadow?
- One line python code to remove all the strings that doesn't start with T or t and if they contain number greater then 6
- Recursively keep only even values in a multidimensional array
- How to remove an item from a list in Scala having only its index?
- PySpark filtering
- Filtering data in R, in a for loop
- How to remove duplicate elements from each row of a 2d array?
- Remove duplicate values per row of a 2d array
- Find the first row with a qualifying column value in a multidimensional array
- Find the parent key of the first qualifying row in each subset of a multidimensional array
- Find the first row of a 2d which contains all required associative elements
- Filter rows of a 2d array which contain two specified column values
- Find the first occurring array row which contains a search value and return the first level key
- Search for a column value in a 2d array and return its first level key
- Return the first level key upon finding a qualifying subarray in a multidimensional array
- Search for a value in the 3rd level of a 3d array and return the first level key
- Get last row that satisfies a condition using pandas groupby
- Summarize data with Java streams
- Pandas equivalent of GROUP BY HAVING in SQL
- Filtering multiple items in a multi-index Pandas dataframe
- Creating reusable and composable filters for Pandas DataFrames