> For the complete documentation index, see [llms.txt](https://docs.rasgoml.com/rasgo-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rasgoml.com/rasgo-docs/rasgo-0.1/overview/user-defined-transforms/utilities/cleanse_name.md).

# cleanse\_name()

Utility to make a string SQL safe so that it can be used as an alias for a new column.

Takes the following actions on a string:

1. remove double quotes
2. replace spaces and dashes with underscores
3. cast to upper case
4. delete anything that is not letters, numbers, or underscores
5. if first character is a number, add an underscore to the beginning

## Parameters

| Type   | Description                                                                   |
| ------ | ----------------------------------------------------------------------------- |
| string | text to make SQL safe; works on column names, table names, row values, etc... |

## Example

```sql
SELECT *

<div data-gb-custom-block data-tag="-"></div>

    , {{math_op}} as {{cleanse_name(math_op)}}

<div data-gb-custom-block data-tag="-"></div>

FROM {{source_table}}
```