In the SAP Analytics Cloud data preparation environment (data wrangler), both the Custom Expression Editor and the Transform bar are used to modify and cleanse data within a dataset. The Custom Expression Editor allows for the creation of complex formulas using functions like REPLACE() or SUBSTRING() to programmatically remove specific characters from a column. The Transform bar offers smart, context-aware suggestions. For instance, by selecting a value in a column, it can suggest a "Replace" transformation, which can be configured to replace certain characters with an empty string, effectively deleting them.

B. Formula bar: This is used within a story (e.g., in a table widget) to create dynamic, front-end calculations for visualization, not to permanently transform the underlying dataset.

C. Calculation editor: This is used within the Modeler to create calculated measures or dimensions. It defines analytical logic for the model, not for cleansing the raw source data.

1. SAP Help Portal

SAP Analytics Cloud - Applying Custom Expressions to Transform Data: "You can create a custom expression to transform your data... The custom expression editor lets you create formulas using a combination of columns

functions

and operators." This document details the use of the editor for data manipulation

which includes deleting characters via functions.

2. SAP Help Portal

SAP Analytics Cloud - Applying Transformations in the Data Wrangling View: "The smart transformation bar suggests transformations that you can apply to your data." This page describes the functionality of the transform bar

which includes actions like "Replace values

" a primary method for deleting characters.

3. SAP Help Portal

SAP Analytics Cloud - Adding Calculations to a Table: "You can add simple calculations directly to a table using the formula bar." This reference clearly places the Formula Bar's function within a story's table

distinguishing it from dataset preparation.

4. SAP Help Portal

SAP Analytics Cloud - Create a Calculation in the Modeler: "You can create calculations in the Calculation Editor... Calculations can be created for measures and dimensions." This source confirms the Calculation Editor is a tool for the modeling environment

not data wrangling.