formulas in the content center

[Simoarr]

Good morning to all, my name is simon and for just over 1 month I have changed work and I am using inventor .
I'm finding myself in a situation where I created my libreira, copied the family I need from the content center, and I stuck to the modification of the "column expression" within the " column property"

I should create a column that, through existing parameters, reproduces my corporate encoding. . .

the problem is that I should use formulas similar to those of excel (e.g. string.estrai, etc.) and not accept them.
in the online guide are not specified which formulas can be used. . .

I need your help.. .

I attach an example of a column created for example. . .
Thank you very much

 

[DrBarde]

creating it in this way unfortunately is really complex.
because where I work I also take care of the whole part of management, following courses and what else I was advised to always pass by excel through special command, and indeed it turns out all simpler and immediate.

 

[batleo]

hi you pass from excel but not always formulas remain, only values remain, I can advise you to lose that extra hour and do it as from image above, then other thing I can recommend is to tie iproperties, for example number of warehouse with your code

 

[Simoarr]

thanks for the answers.
actually if I step by excel, at closing I only care about values and not formulas.

to apply formulas... Is there a list of the formulas accepted by that camp somewhere? I searched but I can't find anything. . .

Thank you.

 

[batleo]

I didn't find a list.
but are divided into strings, boolean, real and integer, I try to make some examples
I create the column "displayname" type string
vt.&{codice_magazzino}&" tcei- "& {designation}&" "&{material_alias}

in this way to each line you fill yourself with the values between { }

I create the column " typology" type boolean
can be 1 - 0 put it as key column and then you create the 2 options for the same row

etc.

 

[Simoarr]

Thank you, I will try your solution

 

[tzadik]

Is this a profile (to be used in the chassis generator) or single components (so there is an ipt, saved in the folder of the content center)?