Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago
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.
Need Help
  • AbhinavJoshi's avatar
    AbhinavJoshi
    3 years ago

    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}})

  • PowerBINoob24's avatar
    PowerBINoob24
    3 years ago

    So easy once you know where to look.  Thanks!

AbhinavJoshi's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
3 years ago

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}})

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago

So easy once you know where to look.  Thanks!