1

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 !!!

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • UweG
    • UweG
    • 2 mths 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]+")

    Like
Like1 Follow
  • 1 Likes
  • 2 mths agoLast active
  • 1Replies
  • 42Views
  • 1 Following