Remove delimiter and specific number of caracters before that delimiter

[Betty888]

I have a column which is the output of a group by function that looks like :

item 1 Item 2 Items 3

item 1 Item 2 Items 3

so, in each cell, I have 2 delimiters: “.” and "#(lf)".

My target is to have rows without the numbering and the "." delimiter : 

item 1 Item 2 Items 3

item 1 Item 2 Items 3

Any ideas to help me 🙏

Thanks a lot !

[v-yalanwu-msft]

Hi, @Betty888 ;

You could split column by delimiter ; 

Then delete first column and the final show:

Or Delete before "." 

The final show:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtTLLEnNVTBUitWJVjLS8wRxjMAcYzCnWMEYzCNKXSwA", 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}}),
    #"Extracted Text After Delimiter" = Table.TransformColumns(#"Changed Type", {{"Name", each Text.AfterDelimiter(_, "."), type text}})
in
    #"Extracted Text After Delimiter"

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Betty888]

Many thanks ! 

I tried this soltuin, but it didn't work in my case, because the delimiters occur several times ...

Thanks again and have a nice day ! 

[wdx223_Daniel · Accepted solution]

NewStep=Table.TransformColumns(PreviousStepName,{"column name",each Text.Combine(List.Alternate(Text.SplitAny(_,".#(lf)"),1,1),"#(lf)")})

[Betty888]

Many thanks !

This works magically on my data, all look perfect now !!!!

You saved my day 🙂 

Thank you again !