Forum Discussion

Shelley's avatar
Shelley
Post Prodigy
2 years ago
Solved

How to Remove Multiple Substrings from a String of Text in Power Query

Hi Team, I need to remove specific strings from the end of a string; however, not every field contains these values, so I cannot simply remove a certain number of characters from the end of the stri...
Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    You can use 

    = Table.TransformColumns(#"Changed Type", {{"Job Title", each Text.BeforeDelimiter(_, " Level "), type text}})

    This assumes that the word 'Level' will not appear in a job title you want to keep.

jgeddes's avatar
jgeddes
Super User
2 years ago

You can use 

= Table.TransformColumns(#"Changed Type", {{"Job Title", each Text.BeforeDelimiter(_, " Level "), type text}})

This assumes that the word 'Level' will not appear in a job title you want to keep.