Is there a list of supported Computed Field functions somewhere.
In my particular case I am trying to extract the last 'x' characters from a string and convert them to an integer.
I had hoped that a to_number(right(FIELDNAME,2),'99') would have worked, but it says invalid formula.
Is there a way to do this?
If not last part of this, can I extract the first part of a string, or even just a predefined location?
Thanks
Solved! Go to Solution.
Solved by bastien.mazeran. Go to Solution.
Hello Sten,
The RIGHT() function does not exist in PostgreSQL. Instead, you could use the rtrim() function.
Below is an example of the computed formula I use in my FIELD_B to remove the x string found in my FIELD_A. Both fields are defined as single line text.
rtrim(FIELD_A, 'x')
I hope this helps.
Regards,
You are right, this information is very useful to other users!
Thank you.
Can't find what you're looking for? Ask the community or share your knowledge.