10

I'm running into issues referencing column names in SharePoint Designer 2010 when the names have spaces in them. This is discussed in this blog post.

For example, I've tried using the following code:

<xsl:value-of select="@Primary Phone"/>

In design view, Designer gives this error:

Failed setting processor stylesheet : 0x80004005 : Expected token 'EOF' found 'NAME'. @Primary -->Phone<--

"Primary Phone" is one of the built-in columns of SharePoint 2010. I've seen where it replaces spaces with "Column_x0020_Name" but not sure about how this is being done.

How do you reference a column with a space in it? I'm going to not use spaces from now on for custom columns, but for built-in columns, what do you do? Thanks.

|improve this question
11

SharePoint indeed converts spaces to _x0020_ for internal names, because this is supposed to represent the url encode %20 (aka space). Because of this reason, you should prevent using spaces in field name (and staticname), as you've mentioned yourself. You can keep spaces in the display name.

In code fragments you can also use:

XmlConvert.EncodeName = converts all the special characters to equivalent _x00xx_
XmlConvert.DecodeName = converts all the _x00xx_ back to the special characters.
|improve this answer
  • 2
    Just a note on this. To get the correct name to use in your code, Edit the list settings, click on the column and use the name as shown in the URL. Example : Field=My%5Fx0020%5Fcolumn . I named the column "My column" – Fox Jul 13 '11 at 7:33
  • 1
    Yes, I do what Fox suggests quite a lot. Note, however, that %5F is the URL encoded _ character. I find asciitable.com a useful reminder of what the different hexidecimal codes for the characters are - letters other than space can be encoded this way, though space is the common one. – Andy Burns Jul 13 '11 at 7:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.