How to use "TextCombined"code when header has quotes

[Timxyz]

Hello, I am using the following to expand a column

#"TextCombined8" = Table.TransformColumns(#"TextCombined7", {{"HSD Models and Methods you would love to practice more with the support of a & ""method mentor"" & from the network", each if _ is list then Text.Combine(_,"|") else _, type text}})

The advanced editor says there are NO errors but when I click the Done button I get the error message

Expression.Error: The column 'HSD Models and Methods you would love to practice more with the support of a & "method mentor" & from the network' of the table wasn't found.Details:
HSD Models and Methods you would love to practice more with the support of a & "method mentor" & from the network

How do I deal with the quotes properly?

Thanks

 

[MarcelBeug]

It depends on the actual name of your column. Possibly you need to provide sets of 4 double quotes (click on the picture to enlarge):



Maybe you should consider other column names :wacko:

 

[Timxyz]

Hello Marcel,

Unfortunately I have no control over the column names

the ampersand in the post were a mistake, here is what I tried

#"TextCombined8" = Table.TransformColumns(#"TextCombined7", {{"HSD Models and Methods you would love to practice more with the support of a """"method mentor"""" from the network", each if _ is list then Text.Combine(_,"|") else _, type text}})

Alas no luck I still get the same error

Expression.Error: The column 'HSD Models and Methods you would love to practice more with the support of a ""method mentor"" from the network' of the table wasn't found.Details:
HSD Models and Methods you would love to practice more with the support of a ""method mentor"" from the network

 

[MarcelBeug]

It still depends on your actual column name which you didn't share so far...