Forum Discussion

Copper Contributor

Jul 21, 2022

Solved

How to extract the bigger number from the first bracket?

Hi!

May I ask if it's possible to get the expected result below? Unsure if I should use regexextract. I can get a number but not the expected one.

Here's the screenshot

Here's the link:
https://1drv.ms/x/s!Ar0aOsqJ5C6FlEdRYFGV2cq6vIjA?e=C7UJQ7

Thanks,
Cheryl

Formulas and Functions

OliverScheurich

=IFERROR(TRIM(MID(A2,SEARCH("[0-",A2)+3,FIND(" Booking]",A2,SEARCH("[0-",A2)+3)-(SEARCH("[0-",A2)+3)-5)),0)

Maybe with this formula.

4 Replies

Martin_Weiss
Bronze Contributor
Jul 22, 2022
Hi Cheryl

I would use Power Query for this task. Load the source table in PQ and get the results in a separate table. Attached please find an example. You just need to right click in the green result table and choose "Refresh", if you have added more records in your source table.

Extract_Hours.xlsx18 KB
- Cheryl
  Copper Contributor
  Jul 22, 2022
  Thank you!! I've never used PQ and will explore more about it. Interesting to know!
OliverScheurich
Gold Contributor
Jul 22, 2022
Cheryl
=IFERROR(TRIM(MID(A2,SEARCH("[0-",A2)+3,FIND(" Booking]",A2,SEARCH("[0-",A2)+3)-(SEARCH("[0-",A2)+3)-5)),0)
Maybe with this formula.
- Cheryl
  Copper Contributor
  Jul 22, 2022
  OliverScheurich Yes it works!! Thank you so much!!