Forum Discussion

a68tbird's avatar
a68tbird
Icon for Resolver II rankResolver II
8 years ago
Solved

Replace Values in Headers

Hello All,   I'm creating a function that will cleanse and model a monthly invoice that we receive. The problem with this invoice is that some months the headers have underscores between the words (...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    a68tbird,

    Change your code to the following:

    = Table.ReplaceValue(#"Transposed Table","_"," ",Replacer.ReplaceText,{"Column1"})


    There is an example for your reference.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

a68tbird,

Change your code to the following:

= Table.ReplaceValue(#"Transposed Table","_"," ",Replacer.ReplaceText,{"Column1"})


There is an example for your reference.


Regards,
Lydia