Return to FileMaker.com
I have a field that can contain a string in the form of : [Txxxx-xxxxx] Where the x can be different.
I need two things :
A calculation that isolates this number, i need this to find other tickets in the system.
How can this be done in filemaker.
It is for a internal ticket system for questions.
you said you need two things and then only specified one?
If your values all follow the same pattern you can just use:
Filter( your field ; "0123456789-" )
You could also use:
Substitute( your field ; "T" ; "" )
Right( your field ; length( your field ) - 1 )
Retrieving data ...