Extract text after delimiter is not working as expected in PowerQuery

[LP280388]

Hi Team,

I am trying to extract data after a delimiter which works fine when we have the delimiter in the value. For the records where delimiter is not present its giving blank after adding "Extract text after delimiter" in power query.

Data : 

Output :

How to make sure that I get "Not Covered" also included in the output

[tamerj1]

Hi @LP280388 
Please use the following code

= Table.AddColumn(#"Changed Type", "New Column1", each if Text.Contains ([Column1], "-" ) then Text.AfterDelimiter([Column1], "- ") else [Column1])

[LP280388 · Accepted solution]

I think I found the solution after 15 mins of trial and error. 

For those who are stuck like me. Need to go to "Advance option" in the step and make sure to select the "Scan for delimiter" > "From the end of the input" option