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

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

I believe I may know what's going on...I was sure that Replace Values could interpret "contains text" instead of an exact match. Nothing is being replaced because no cells are exactly "_".  So, how can I replace where value contains an underscore?