Problem using an if statement with a column name with a "/" in it

[Anonymous]

I have a line like this in my query:

= Table.ReplaceValue(#"Replaced Value11", each [CBT], each if [Customer Name/Customer ID]= "Sample Name" then "Something" else [CBT],Replacer.ReplaceValue,{"CBT"} )

and it generates an error in the if statement pointing to the text prior to the / saying Expression.SyntaxError: Invalid identifier.

However, if I change the column reference in the if statement to a column name without a / in it, it works fine.  Can someone explain why it doesn't like the / in the column name?  Will a / in the column name cause problems in other areas?

thanks,

[AnkitBI]

Try below using #"Customer Name/Customer ID". 

= Table.ReplaceValue(#"Changed Type", each [CBT], each if [#"Customer Name/Customer ID"]= "Sample Name" then "Something" else [CBT],Replacer.ReplaceValue,{"CBT"} )

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[Anonymous]

Thanks @AnkitBI  for the tip.  Do you know why the behavior in the if statement is different for column names with a / and those without?  Should I avoid using / in my column names?

thanks,

Chad

[AnkitBI · Accepted solution]

Just a Syntax thing to handle special characters in Column Name. Ideally we shall avoid special characters in Name if not necessary.

---