If statement in Power Query that removes last letter

[Anonymous]

Hi! 

I am trying to make a new column that has an if statement in a Power Query that removes the last letter if it is equal to  "*" This is what i got so far and i am not sure on how to fix it. 

All help would be greatly appreciated!

All the best,

Pétur

[az38 · Accepted solution]

Hi @Anonymous 

try Text.BeforeDelimiter

= Text.BeforeDelimiter([guestName], "*")

[Greg_Deckler]

...then Text.Start([guestName],Text.Length([guestName])-1)...

[Anonymous]

This was actually Giving me an Error, was messing up with the Code when i took the picture so thats why i forgot it probably!