Transforming Cells

You can apply text transforming, numeric transforming, and other common transforming to the cells in a column.

On the project data page, click the header of the column containing the cell values that you want to edit, and then click Edit cells. Select a transforming method:

Click Transform to transform cell values according to a regular expression.
Take the Sample-students_records dataset as an example.
1. On the project data page, click Edit cells > Transform from the ExamDate column menu.
2. In the Expression field, enter value.toDate().toString("yyyy-MM-dd"). Click OK to transform the cell values.
  The examination date is changed to the yyyy-MM-dd format.
Click Numeric Transforms to perform mathematics calculations on numeric data. The following options are available:
- Numeric rounding
- Numeric ceiling
- Numeric flooring
- Numeric logarithm
Click Common transforms. The following common transforming options are available:
- To clean up white spaces, use the following functions:
  - Trim leading and trailing white spaces
  - Collapse consecutive white spaces
  - Convert empty string to null
- To replace special characters with HTML entities, use the following function:
  - Unescape HTML entities
  Sometimes, your data exported from a web application may contain HTML codes. In HTML, special characters are escaped by a number or with custom shortcuts. Therefore, use this function to transform your data into legible one.
  
  For example, if your data contains HTML entities, such as the company name is AT&T, after clicking Unescape HTML entities, the company name is transformed to AT&T.
- To change the capitalization styles, use the following functions:
  - To titlecase
  - To uppercase
  - To lowercase
- To remove all the cell values, use the following function:
  - Blank out cells