Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If statement in Power Query that removes last letter

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

 

Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try Text.BeforeDelimiter

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

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    try Text.BeforeDelimiter

    = Text.BeforeDelimiter([guestName], "*")
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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!