EXTRACTING NUMBER - am I doing something wrong?

Ok, so I have an OCR function implemented and OCR_Text column (LongText). Sample data like this:
2X_5_5acfb8a200e7fda41d4201a144597df9d6ce009a.jpeg
I would like to extract digits out of the OCR_Text and store it as Number so I’m doing following tests with virtual columns:
Column “temp3” =EXTRACT(“NUMBERS”, [OCR_Text])
Column “temp4” =EXTRACTNUMBERS([OCR_Text])
the results are as follows:
2X_2_25bc1b536b4709e5a4242f8556777eba13bf1110.png

The funny thing I noticed that EXTRACT(“NUMBERS”, TRIM(SUBSTITUTE([OCR_Text], " ", “”))) returns no List/Value

1 7 894
7 REPLIES 7
Top Labels in this Space