Forum Discussion

KCinMelbourne's avatar
KCinMelbourne
Icon for Resolver I rankResolver I
7 years ago
Solved

Replace Value in Whole Table

Hi guys,   I've had issue in the past where Project Online data pulls in with 'non printable characters'. It's a pain because it appears as a space but when you try to (for example) merge the table...
Need Help
  • sckienle's avatar
    sckienle
    7 years ago

    You can do this by using the Table.ColumnNames function in replacement of the specific column list.  E.G. Table.ReplaceValue(#"Last Step",null,"-",Replacer.ReplaceValue,Table.ColumnNames(#"Last Step"))

sckienle's avatar
sckienle
Icon for Advocate II rankAdvocate II
7 years ago

You can do this by using the Table.ColumnNames function in replacement of the specific column list.  E.G. Table.ReplaceValue(#"Last Step",null,"-",Replacer.ReplaceValue,Table.ColumnNames(#"Last Step"))

philipblondewwt's avatar
philipblondewwt
New Member
7 years ago

This solution works and resolves replacing values in columns that can have changing names.