Skip to main content
venkateshg4665
venkateshg4665
Known Participant
July 1, 2025
Question

Extract Integers from Text field in recpord

  • July 1, 2025
  • 6 replies
  • 4 views

Hi everyone,

I am working on a task where I want to compare values in a read-only grid. The data in the field consists of text-type values, for example: k(100), k(101), SH(300).

While applying filters in the read-only grid, I want data whose values are greater than 100. Here, we should check only the number in the text.

is there any possibility to achieve this functionality

6 replies

stefanhelzle0001
stefanhelzle0001
Brainy
July 1, 2025

Create a custom record field, choose expression, and use the tointeger() function to extract the number. Then you can use this new field for sorting and filtering.

venkateshg4665
venkateshg4665Author
Known Participant
July 1, 2025

 [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] Thank you for the reply, I tried this approach, but I am getting this error when i used tointeger(recordtype!fieldName)
error:
Test currently unavailable due to an error There was an error with the custom record field "Custom Record Field". Expression evaluation error at function 'tointeger': Could not cast from Record Field to Number (Integer). Details: CastInvalid

stefanhelzle0001
stefanhelzle0001
Brainy
July 1, 2025

You have to reference the field value, not the field.

tointeger(rv!record[recordtype!YOUR_RECORD.FIELD])

Terms & ConditionsAccessibility statement