Computed Field functions

[sten]

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

[bastien.mazeran · Accepted 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,

[sten]

Perfect. Thank you.

I guess I was looking at the wrong version of PostgreSQL. Version 9.x has a right function.

I was looking at version 9.x.

[sten]

Let me correct my typo in the previous post.

I think the information would be helpful for other people too.

Use PostgreSQL version 8.1 as reference for functions, not the newer 9.x.

Autodesk, please correct me if I am wrong.

[sara.murray]

You are right, this information is very useful to other users!

Thank you.