Need some help related to regex if possible.
I have a table in which one of the column consist of Remarks.
From this remarks column i need to collect a number which can be upto 9999(i.e between 1 to 9999)
This number should be collected only if that column contains some keyword. And the number should be just before or after that keyword.
For example: consider ‘number’ is the keyword.
number is 20
20 is the number
number = 20
so if remark column contains something like above then i need to fetch 20
Is it possible to create a regex? Can you please help