Is there a way to delimit text from the project name field?

[Christina_Jarosz]

We have a calendar that displays specific tasks on projects. However, because of the phrasing we have of our project names it can be hard to read.

Is there a way to delimit text by character? For example 999999-PSG-Project Name

The numbers and the letters may vary in length. I'm not sure how to separate the 'Project Name' from the rest of it.

Or create a calculated field that only pays attention to what's after the second hyphen?

[Surya_Lakhani · Accepted solution]

Hi Christina,

If the Project Name is always going to be after the second hyphen you can use the expression below. Not sure if it would work in calendar but a calculated field either at the project level or task level (you will have to update the expression for this) would definitely work:

SUBSTR(SUBSTR({name},SEARCH("-",{name},0)+1,LEN({name})),SEARCH("-",SUBSTR({name},SEARCH("-",{name},0)+1,LEN({name})),0)+1,LEN(SUBSTR({name},SEARCH("-",{name},0)+1,LEN({name}))))

[Christina_Jarosz]

You are absolutely the BEST! Thanks!

[Madalyn_Destafney]

Wow, nifty! What is LEN?

[ChrisStephens]

In this case it returns the length of the string as an integer

[SharonFl2]

I was wondering if we could lengthen the field for Project Name because we have to hover over it whilst looking at a project in order to see the full name of the project as it only shows the first 18 characters or so. 

Can someone help?

[Madalyn_Destafney]

Hi, are you on a small screensize or have your window minimized? I believe a project name in WF can be up to 56 characters until it add the ellipses at the end. I just did a test and can confirm. Or are you referencing seeing names of projects in a report? If that's the case you can expand that column's width in the report.

[SharonFl2]

Even if I'm viewing on my large monitor - i still can't see the whole project name (see screen shot). If there is a way to make the Project Name font smaller or -- have that field be wider and make the other fields (Percent Complete/Project Owner/Planned Completion/etc) less wide?

[Madalyn_Destafney]

Interesting. You cannot customize the real estate given to the items in the project header, unfortunately. Last thing I want to check if your zoom, are you seeing it this way even at 100% or 90% zoom? I'm seeing longer project names:

Not seeing anything in documentation on project name specifically. If your zoom is fine, and you're in an up-to-date supported browser (basically anything but IE), and still seeing it like your screenshot I'd ask WF support about it.