How do I reference a field name which includes a slash in Power Query

Viewed 4574

In Excel 2016 Get & Transform ("Power Query") it appears to be totally valid to have a field (column) name containing a slash character. However, when I try to reference this column, I can't find any way to escape the slash to make the reference work. How can I do this?

Specifically, the following code is accepted:

Table.AddColumn(#"Capitalize", "ABC Table", each Table.FromColumns({Text.Split([ABC], ",")}))

...but the following is not:

Table.AddColumn(#"Capitalize", "ABC Table", each Table.FromColumns({Text.Split([ABC / DEF], ",")}))

...presumably because of the slash in [ABC / DEF].

How can I escape this slash?

1 Answers
Related