Custom column?

[Anonymous]

Hey there,

I have this column :

I need to make a custom column that merges this column so the output is: this 22nd day of march 2001 douling ground fofrt ord 1990 101

This example is for the first row.

Can someone help me?

[Anonymous · Accepted solution]

Hi @Anonymous 

Based on your sample, you can add a custom column

Text.Replace( Text.Combine( List.RemoveItems( Text.SplitAny([Column1],"'"), {",","[(",")]","),(","0","1"})," "),","," ")