Is there a way to delimit text from the project name field? | Community
Skip to main content
Christina_Jarosz
Christina_Jarosz
Level 9
January 26, 2023
Solved

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

  • January 26, 2023
  • 1 reply
  • 1437 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by SuryaLakhani

    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}))))

     

    1 reply

    SuryaLakhani
    SuryaLakhaniAccepted solution
    Level 4
    January 27, 2023

    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
      Christina_JaroszAuthor
      Level 9
      January 28, 2023

      You are absolutely the BEST! Thanks!

      Terms & ConditionsAccessibility statement

      Loading footer...