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 i...
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"})," "),","," ")

     

     

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"})," "),","," ")