text edit functions supported in expressions
1 1

7 posts in this topic

Hello,
would be nice to have as text "editing" functions supported for make some custom attribute auto naming or renaming, based on other attributes, etc.
functions like :
REPLACE, UCASE, LCASE, CHAR_LENGHT, etc.


I am quite new here, so i don't know if this request have been already made or is on track, but that would be really helpful :)
Cheers

Eric

Share this post


Link to post
Share on other sites

Hello, thanks for your response.
Yes i saw the list of supported functions before create this thread, that is why i said that <<it would be nice to have>> some other "test editing" functions.
We have some dependencies between hundreds asset's names ans label attributes, so it would be useful to automatically create strings.
eg: if we have this kind of Label attribute, manually typed : "Parisian Aged Ground Pavement" we would like to be able to make a "Name" expression attribute that would automatically format it like this: "parisian_aged_ground_pavement"

I guess i can replace the " " by the "_" with the existing supported functions (it would be anyway more simple with a "REPLACE" function) but not possible to convert caps to lowercase.
I propose this because we have hundreds assets to manage on each project.

Cheers and as i am quite new to ftrack i would like to congrats everyone for your incredible tool ! Team begin using it and seems to really like it

Eric

ps: sorry for my english, i hope to be understandable :D

Share this post


Link to post
Share on other sites

So here is the very beginning of an expression i have so far

:

{func.CONCAT(
   func.SUBSTRING(
      self.graph_label, 
      1,
      func.LOCATE(' ',self.graph_label)-1
   ),
   '_',
   func.SUBSTRING(
      self.graph_label, 
      func.LOCATE(' ', self.graph_label)+1, 
      func.LOCATE(' ', 
         self.graph_label, 
         func.LOCATE(' ', 
         self.graph_label)
      )
   )
)
}


So for the attribute Label "Parisian Aged Ground Pavement" it give me the attribute Name "Parisian_Aged Gro" but i still have caps

This is just a very beginning, not complete 😛


With REPLACE AND LOWER, i would have something like that :

{func.LOWER(func.REPLACE(self.graph_label, ' ', '_'))}


Regards

Share this post


Link to post
Share on other sites

Hi Eric,

Thanks for the update and feedback.
I have added your input as an enhancement request.
So this will evaluated by the team.

Thanks again for your input on this.

Regards,
Johan

Share this post


Link to post
Share on other sites

Hi Johan,
That's sounds very good !!! Looking forward for that new functions to be supported and have full & easy control on expression custom attributes ! 😍

Thank you very much
Regards

Eric

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
1 1