In Google Sheets, I'm trying to return numbers from within a text string.
The numbers are values of the property named either item_id
or item_ids
.
I've tried the REGEXTRACT function but I'm struggling.
Example 1
- Text in cell A1
<!-- wp:shortcode --> [aces-unit-1 item_id=""1236""] <!-- /wp:shortcode -->
- Expected Result
1236
Example 2
- Text in cell A1
<!-- wp:shortcode --> [aces-bonuses-1 items_number=""4"" external_link=""1"" category="""" items_id=""1563, 2372, 3855, 3980"" exclude_id="""" parent_id="""" columns=""4"" order="""" orderby="""" title=""""] <!-- /wp:shortcode -->
- Expected Result
1563, 2372, 3855, 3980
item_id
vsitem_ids
is a typo and the string is always one or the other, edit your question to fix that and I can update the solution.