number() function stops convert strings with letters

Hello, I think that function number(), was converting strings like "XX23" to number 23... I've used it lot to convert record id to number for function record(Table,number(id)) .

What happend that number() is not workin as it was? What I can do ? All formulas are now returning 0 !!!

1 reply

    • UweG
    • 1 yr ago
    • Reported - view

    To my knowledge, this has never worked to convert a string that contains letters as well as numbers into a number. The result was always 0. It is different if you apply number to the record ID as follows: (select TABLENAME where FIELD=xy).number(id).
    But you can solve it as follows:
    extractx(„FX3404", "[0-9]+")

Content aside

  • 1 yr agoLast active
  • 1Replies
  • 89Views
  • 1 Following