Forum Discussion
Solved
Stripping characters from string
I have a number of records that have an employee's title and name. The format is Title (Name). Is there a way to strip all characters away except for the employee's name? Thanks in advance.
Thanks for clarifying. You can use Extract function in Power Query Editor. Please find the code and sceenshot attached.
#"Extracted Text Between Delimiters" = Table.TransformColumns(#"Changed Type1", {{"Name", each Text.BetweenDelimiters(_, "(", ")"), type text}})So easy once you know where to look. Thanks!
Thank you. While that works, I'm not looking to split the columns. Just need to strip everything but the name.
Thanks for clarifying. You can use Extract function in Power Query Editor. Please find the code and sceenshot attached.
#"Extracted Text Between Delimiters" = Table.TransformColumns(#"Changed Type1", {{"Name", each Text.BetweenDelimiters(_, "(", ")"), type text}})
So easy once you know where to look. Thanks!