Forum Discussion

acerNZ's avatar
acerNZ
Helper III
5 years ago
Solved

Multiple queries on custom column ?

Hi Experts, Sorry if the subject is misleading I have a custom column with the following  Step1: = Table.TransformColumnTypes(#"Added Custom",{{"Postcode", type text}})   The out is basically po...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi acerNZ 

    Why the need to do it as 1 step?  Just curious.

    Try this

     

    = Table.ReplaceValue(Table.TransformColumnTypes(#"Added Custom",{{"Postcode", type text}}),",","",Replacer.ReplaceText,{"Full Address"})

     

    regards

    Phil

acerNZ's avatar
acerNZ
Helper III
5 years ago

Hi PhilipTreacy 

Thanks a lot. Yes it did work and apologies, did not notice there was a solution next line, I realized this just now.