I have text in a column named "name", for example
RPG Notebook 5"x8"
I need to replace Notebook 5"x8" with N58
I am struggling to get the syntax right because of the quotation marks in the original text.
= Table.ReplaceValue(#"Replaced Value3","Notebook 5"x8"","- N58",Replacer.ReplaceText,{"name"})
returns
Expression.SyntaxError: Token ',' expected.
Any help greatly appreciated.
This worked for me.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Replaced Value" = Table.ReplaceValue(Source,"Notebook 5""x8""","N58",Replacer.ReplaceText,{"name"})
in
#"Replaced Value"
When I follow your scenario, and just by clicking in the user interface, the M-code looks like this:
Thanks Alan & Riny,
Tried those solutions but text was not replaced.
Finally got it to work with
Table.ReplaceValue(#"Replaced Value3","Notebook 5”x8”","N58",Replacer.ReplaceText,{"name"})
Seems like the double quotes after the 5 & 8 were not the same as normal double quotes, nor were they 2 single quotes!
I selected a Notebook in the name column then copied the Notebook 5"x8" bit in the Preview Pane and pasted that into the M-Code, after that everything worked fine.
The Source file is actually a CSV file downloaded from a web site which is then converted to an .xlsx file, maybe that accounts for the strange double quotes.
