topic Concatenate Fields? Descriptor this... in Fusion Manage Forum

Concatenate Fields? Descriptor this...

Anonymous — Wed, 26 Sep 2012 17:34:22 GMT

First, is the "Descriptor" available to me for use in new fields?

Second, how can I "concatenate" fields together to accomplish something similar?

Thanks In Advance,

John

Re: Concatenate Fields? Descriptor this...

Anonymous — Wed, 26 Sep 2012 18:45:00 GMT

Here's an attempt to use a Computed Field... see the formula @ bottom...

I don't know how to format the text... is there a guide?

Re: Concatenate Fields? Descriptor this...

michelle.stone — Wed, 26 Sep 2012 19:49:50 GMT

There's a tutorial on the Wiki for Computed Fields - this should help!

http://wikihelp.autodesk.com/PLM_360/enu/Community/Tips/Configuring_Fields/Computed_Fields%3a_Small_but_Powerful

For string concatination - here's a quick example with name and prefix:

Hope that helps!

Michelle

Re: Concatenate Fields? Descriptor this...

Anonymous — Wed, 26 Sep 2012 20:09:18 GMT

Thanks Michelle.

I'll be studying your Wiki link and catching up on your webinars this evening!

You are appreciated.

Re: Concatenate Fields? Descriptor this...

Anonymous — Wed, 26 Sep 2012 20:18:57 GMT

Oh, BTW, I did discover "Item Descriptor" in the Workspace Field entry box (after making a Field a Picklist...), the referring WS's Descriptor is not exactly what I needed. I'll be trying the concatenation method OR simply displaying more fields in my Default View.

Re: Concatenate Fields? Descriptor this...

michelle.stone — Wed, 26 Sep 2012 20:34:08 GMT

When I wear my 'end user' hat, I find I prefer to set up my own left filter views rather than relying on the descriptor anyway.

Michelle

Re: Concatenate Fields? Descriptor this...

ForrestJudd — Fri, 28 Sep 2012 16:39:13 GMT

I have a somewhat related question - what if I wanted to concatenate only part of a field with another using a computed field? For example

Field1 = Test

Field2 = 123

I want Field3 = Tes12

which is the first three characters of Field1 and the first two characters of Field 2. I've tried syntax like

Field1.substring(0,3) + Field2.substring(0,2)

Field1.substr(0,3) + FIeld2.substr(0,2)

Field1.slice(0,3) + Field2.slice(0,2)

None of those will work in a computed field. Can I get a substring of another field? I've tried even just getting the substring of one field and that doesn't work either. I've also tried casting it, like so

CAST(Field1 as String).substr(0,3)

That doesn't work either. Is there a more general reference on the syntax for computed field formulas?

Re: Concatenate Fields? Descriptor this...

Anonymous — Mon, 01 Oct 2012 15:26:17 GMT

Forrest,

For the particular solution that you are looking for, this would be best obtained by using a Javascript behavior coding, which is a lot more powerful and flexible then the available SQL scripting that comes with the Computed fields.