arraysregexgoogle-sheetsgoogle-sheets-formulaarray-formulas
How to split and find last index in Google Sheets?
I need to achieve something like following in Google-sheets:
tag_name
A_B_C C
A_B_C_D D
I am using following formaula:
=INDEX(SPLIT(B2, "__"), 0, 3)
I want to dynamically pass last index of the set of values returned by split.
Solution
You can try REGEXEXTRACT formula, I am assuming your data range starts from "A1". Put this formula in "A1" and fill it down per your requirement
=REGEXEXTRACT(A1,"\S$")
- How to remove one or more fields from JSON-encoded string?
- What do [], @ and {} mean in the context of this associative array declaration?
- JavaScript - reverse an array in a specific way
- How to allocate a 2D array of pointers to a struct
- Creating a hierarchical array of objects with many sub-levels
- What does an assignment expression involving a variable ending in empty square braces mean?
- How can I make a method take an array of any type as a parameter?
- Dynamic markdown from json in Github readme.md
- check if all elements of an array have the same value in Swift
- Does the internal index of a PHP array automatically increase, if I create an array element with []?
- Python Linear Regression Predict Error - Array Issue
- Update row data in a 2d array if its identifying column is found in another array
- PHP - Compare two arrays and if there are duplicates remove all matches
- How to increment column values with CodeIgniter's update_batch()
- Group an array of objects by an identifying property
- Kotlin Type mismatch: inferred type is Int? but Int was expected
- How to transfer 2d result set array from CodeIgniter model to the view layer?
- Return only the first and last items of an array in Ruby
- Group 2d array data by a column and create new parent columns and subarrays for each group
- Declare a 0-Length String Array in VBA - Impossible?
- How can I prevent my output array from duplicating a certain value?
- How to remove only one of repeated chars in string using JavaScript
- Range within an array in C
- nodeJS util.format passing an array
- syntax for string array migration
- Error: non-static initialization of a flexible array member in Some Cases but Not Others
- array manipulations and extractions of data by names
- Expected expression before <= token
- Why does a for-in loop over an array not iterate over its elements?
- assign a string to a structure variable in c