Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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}})
Hello @PowerBINoob24. You can achieve this in Power Query Edior using split column by delimiter. First I split it using the "(", and then I do it replace values where I replace ")" with blank to get the name only. Please find the full source code ,and screenshots attached.
let
Source = Excel.Workbook(File.Contents("C:\Users\AJoshi\Downloads\Random2.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Sheet1_Sheet,{{"Column1", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Name", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type1", "Name", Splitter.SplitTextByDelimiter("(", QuoteStyle.None), {"Name.1", "Name.2"}),
#"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Name.1", type text}, {"Name.2", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type2",")","",Replacer.ReplaceText,{"Name.2"})
in
#"Replaced Value"
I hope it helps!
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!
User | Count |
---|---|
144 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |