Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Siboska
Helper II
Helper II

Extract multiple characters from a string

Hi, 

Can anyone help with the following Power Query code: 
I need to extract all "full names" from a string. 

Looks like this:

Input:
Column [Name]
[{"fullname":"Margit Martens","internalemailaddress":"Margit.Martens@gmail"},{"fullname":"Joey Samuelsen","internalemailaddress":"Joey.Samuelsen@gmail.com"}]
 
 

Output:
Column [name]:

Margit Martens, Joey Samuelsen


Have tried with the standard Power Query functions with no luck
Hope someone have some nice solution for this task 

1 ACCEPTED SOLUTION
wdx223_Daniel
Community Champion
Community Champion

=Table.TransformColumns(PreviousStepName,{"Name",each Text.Combine(List.Transform(Json.Document(_),each [fullname]?),",")})

View solution in original post

3 REPLIES 3
wdx223_Daniel
Community Champion
Community Champion

=Table.TransformColumns(PreviousStepName,{"Name",each Text.Combine(List.Transform(Json.Document(_),each [fullname]?),",")})

Siboska
Helper II
Helper II

@Greg_Deckler Thank's for your answer. Will test it tommorow and let you know if the provided solution worked for me

Greg_Deckler
Community Champion
Community Champion

@Siboska Try:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wiq6OUUorzcnJS8xNjVGyilHyTSxKzyxRAFIlqXnFMUo6MUqZeSWpRXmJOam5iZk5iSkpRanFxUhq9aBqHdJB8jFKtTroZnrlp1YqBCfmlqbmFKfm4TcTpFYPrhZipl5yfi7Q3Fil2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}}),
    #"Parsed JSON" = Table.TransformColumns(#"Changed Type",{},Json.Document),
    #"Expanded Name" = Table.ExpandListColumn(#"Parsed JSON", "Name"),
    #"Expanded Name1" = Table.ExpandRecordColumn(#"Expanded Name", "Name", {"fullname"}, {"Name.fullname"}),
    #"Transposed Table" = Table.Transpose(#"Expanded Name1"),
    #"Merged Columns" = Table.CombineColumns(#"Transposed Table",{"Column1", "Column2"},Combiner.CombineTextByDelimiter(",", QuoteStyle.None),"Merged")
in
    #"Merged Columns"


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.