Separating Values In Columns By A Certain Phrase Without Using Power Query

[BO7]

Hello,

I have a description column (see attached file). I am trying to create a new column that only contains the characters after 'Root Cause'. The issue is I cannot use Power Query due to database issues. Is this feasible?

[ajaybabuinturi · Accepted solution]

Hi @BO7,

You can try with below calculated column

RootCauseOnly =
VAR FullText = JIRA[Description]  
VAR RootText = "Root Cause:"
VAR StartPos = SEARCH(RootText, FullText, 1, -1)
RETURN
IF(StartPos > 0,
    MID(FullText, StartPos + LEN(RootText), LEN(FullText)),
    BLANK()
)

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.