Powershell: update column value with full stop in column name

Question

I have a column named: 10. London I need to update the value of this column using Powershell. My script works on columns that do not have a full stop (period) in the name "." The internalName does not work. How do I escape the full stop in the column name? I've tried variations e.g. $item["10'.'London'"]

foreach($item in $items){
  %colValue = $item["Title"]
  if (%colValue -eq "SomeText")
  {
    $item["10. London"] = "NewText"
    $item.Update()
    $List.Update()
  }
}

Couldn't you get a reference to the field by using $list.Fields.GetFieldByInternalName() and then there where you are updating items do $item[$field.ID] = "New Value" or something like that? — Dylan Cristy
– Dylan Cristy, Commented Mar 21, 2017 at 17:36

Cornelius J. van Dyk · Accepted Answer · 2017-03-22 01:00:04Z

0

Try URL encoding the period and space like this:

$item[10%2e%20London] = "NewText"

answered Mar 22, 2017 at 1:00

Cornelius J. van Dyk

7113 silver badges8 bronze badges

Add a comment |

Stack Exchange Network

Powershell: update column value with full stop in column name

1 Answer 1

Your Answer

Hot Network Questions

Powershell: update column value with full stop in column name

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions