How to extract the particular numbers between the below mentioned text?

Questions and Help
1

How to extract the particular numbers between the below mentioned text?
Example:-
Diary No : 1890003/2023(PASSED)
Diary No : 49120/2024(PASSED)
Diary No : 3465998/2025(Under objection)
From the above mentioned 3 examples I want to extract only the diary no.(in digits) without text without year & without status.
The result I want is :-
1890003
49120
3465998
Thanks in advance

2

Hi @Aveg_Paliwal try this:

{text="Diary No : 1890003/2023(PASSED)
Diary No : 49120/2024(PASSED)
Diary No : 3465998/2025(Under objection)"}
{=extractregexall(text, "Diary No : (\d+)")}

1 Like
3

Thank you very much for prompt reply, and it is working.
Can you recommend from where i can learn about these formulas. for a beginner. Thanks

4

I recommend trying to use the AI Write feature in your dashboard.
You can read about these commands in our guides
and specifically here
.

1 Like