Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom column?

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?

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    Based on your sample, you can add a custom column

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

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

     

    Based on your sample, you can add a custom column

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