In Google Looker Studio, you can use regular expressions to transform and format report data.
For a full list of supported formulas, see the Google Looker Studio documentation.
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:
- Add a new column to your table.
- 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.
