Solved: EXTRACTNUMBERS without spaces - Page 2

Christoph_Bucke · 11-30-2020 02:29 PM

Hi,
I have a question about the function ExtractNumbers. The function extracts the numbers found in an OCR text and returns a list.

Do you think the following behavior is intended?
extractnumbers(“41”) : (41) ok
extractnumbers(“41B”) : (4100000000) nok, should in my view be 41
extractnumbers("B464/116) : (116) nok, should in my view be a list (464 , 116)

Do you have an idea how I could get the wanted behavior?

I tried also to substitute each character but digits by one space. Interestingly the last example then returned 464.116
It was ok, when I substituted each character with 2 spaces.

Thanks for any advice

GreenFlux

Yeah, it sucks having to nest 26 SUBSTITUTE()s just to filter out letters, and then there are still special characters to consider. But I think that’s the best we can do with the current functions in AppSheet.

We could REALLY use REGEX, or at least a more powerful SUBSTITUTE() with optional sets of parameters, or something like FileMaker’s FILTER().

Another option is saving the raw value to the sheet, and then using a Google Sheet formula with REGEX to extract the numbers to a new sheet column.

View solution in original post