# capitalise

## Overview

The `capitalise` (the spelling `capitalize` is also supported) statement is used to modify the name of a column and/or the values in a column such that the first character is a capital letter and the remaining characters are lower case.

## Syntax

**`capitalise values|heading [and values|heading] in column|columns`***`ColName1 [... ColNameN]`*

{% hint style="info" %}
After the keyword **`in`**, either of the keywords **`column`** or **`columns`** may be used
{% endhint %}

## Details

The `heading` and `values` keywords refer to the name of an existing column and the values in each row for that column respectively.

Only the first character in the column name or value is converted to upper case. If this character is not a letter, then the statement will have no effect on it. For example applying the statement:

```
capitalise heading in column _vmname
```

will have no effect on the column name as the first character is an underscore. However, applying the same statement to a column called `_VMName` would result in a new name of `_vmname` as after attempting to make the first character a capital (which in the case of the underscore has no effect), the remaining characters are converted to lower case.

Any number of column names may be specified, and any of these may or may not be fully qualified. When applied to values in a column, blank values are ignored.

## Examples

```
capitalise heading in column servicegroup

capitalize heading and values in columns servicegroup Azure.usage.resourcepool chargeinterval

capitalise values in column Region
```