Hi ,
I have a string that is character and I want to extract a 4 number section. The position of the numbers may change
An example of the string may be
value ="Hello 0123 example";
I have tried this but only works if the numbers are in the correct position.
value ="Hello 0123 example";
extract=substr(value,7, 4);
As the position of the number will change how can I extract this?