In Google Looker Studio, you can use regular expressions to transform and format report data.

For example, you can use a regular expression to separate a deal stage name from its identifier and display the result in a separate field.

To create a calculated field:

1. Add a new column to your table.
2. Click Add dimension > Create field.

3. Enter a field name.
4. Add the following formula: REGEXP_REPLACE(Stage, '\\[.+\\] ' , '')

This formula removes the stage identifier and keeps only the stage name.

After you save the field, a new column appears in the table without the stage identifier.

Use regular expressions to extract, clean up, and display data in separate fields.