I have an Application column which includes both the application name and version, and a Version column. Since there is already a Version column, I want to remove the version appended in the Application column since it's redundant. I can't just Split Columns or Extract at the last space delimiter because not all of the Application column entries have versions so the last word in the Application name would be removed instead.
Can someone help me with editing the Replace formula? What I would like to do is use Transform > Replace to take the value in the Version column for each record, look for that value in the same row's Application column name/version combination, and if found, then replace the matched text with an empty value. For example "7-Zip 19.00" in the Application column would display as "7-Zip". Attached is a screenshot.
Replace doesn't let me add the Version column under "Value to Find" so I tried entering just a text value to add the formula, then edited the Replace formula in the formula bar and substituted that text value for the column [Version]. But I'm really, really new to this and apparently also really wrong in what I was attempting because I got an "Expression Error".
= Table.ReplaceValue(#"Reordered Columns","textvalue","",Replacer.ReplaceText,{"Application"})
Substituted text value for column:
= Table.ReplaceValue(#"Reordered Columns",[Version],"",Replacer.ReplaceText,{"Application"})
