How to escape special characters in field name

[Anonymous]

Hello World!

I have a special character in my field name that is causing an error in my load. This field is referenced in a field select function.

fieldselect = "&$top=5000&$select= Author/Title, ASM/Supervisor/Title, Editor/Title, AssignedTo/Title&$expand=Author,Editor,AssignedTo"

The name of the field is "ASM/Supervisor". Does anyone know of a solution to escape this special character within field select?

Thanks in advance.

[Rudz]

This looks like OData. I think you just use ASCII escaping, so / is %2F.

fieldselect = "&$top=5000&$select=Author%2FTitle, ASM%2FSupervisor%2FTitle, Editor%2FTitle, AssignedTo%2FTitle&$expand=Author,Editor,AssignedTo"

This page is a good reference for other special characters: HTML URL Encoding Reference (w3schools.com)

[v-yingjl]

Hi @Anonymous ,

Based on the description, not certain where did you use it in a 'field select function', and what's the error message it shows.

Maybe you can share more details like the error message and the query you have quoted this field for further discussion.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

Not clear if you need to remove special characters from the whole text, if so in Power Query, add the following as new custom column

= Text.Select([Your Field Name],{"a".."z","A".."Z","0".."9"," "})

[Anonymous]

No need to remove. I have a "/" in my field name "ASM/Supervisor" that, when refernced in fieldselect, brings back an error. I need to escape this special character so that the field name is readable.

[Fowmy]

@Anonymous 

Did not understand what is "fieldselect" here. Can you explain a bit not more? Is it power query ?