Convert list of numbers from LongText field to number

[Grover426]

Help Appsheet experts, I'm trying to convert a list of numbers in the LongText field to a number, I tried using this formula EXTRACT("NUMBER", [Quantity]), the quantity field has a list of numbers on each line but it is in text format when trying to apply the formula it only converted the first number in the list but not the rest, any suggestions or contributions for this case I would be very grateful. 

[Steve · Accepted solution]

This looks like a bug. Please contact AppSheet Support for help with this.

Attn @AleksiAlkio