Extract multiple characters from a string

[Siboska]

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":"[email protected]"}]

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 

[wdx223_Daniel · Accepted solution]

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

[Siboska]

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

[Greg_Deckler]

@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"