Hi All,

Im trying to use a split formula as I want to keep all the text on one side of a specific charter for backpack 4.  Can anyone help me with:

A.   How do I write this to extract only the manufacturer

B. Is there a document with a full list of formula and how it can be used?

Thanks

I have actually googled it and figured it out!  But would be good to hear if there is a doc with all formula in....

Thanks

Hello Claire,

You can find that reference here: https://tbmcouncil.jiveon.com/docs/DOC-1213

The document is called Apptio function quick reference (11.8 - 12.6).

Hope this helps.

Wow thanks so very much this is great!

Just glad to help

Another quick list, Functions: Annotated list 

Hello @Claire Thomas!

Looking at the pattern, I see that the manufacturer name is suffixed with a 9 character code. So the following function should get you what you need:

=left(Storage ID,len(Storage ID)-9)

Oh thats also a great answer thanks!