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. The following transforming options are available:

  • Click Transform to transform cell values according to a regular expression.
  • Click Numeric Transforms to perform mathematics calculations on numeric data. The following options are available:
    • Numeric rounding

      Returns an integer that is approximately equal but has a shorter, simpler, or more explicit representation, for example, replacing 2.9 with 3.

    • Numeric ceiling

      Returns the smallest integer that is greater than or equal to a given numeric value.

    • Numeric flooring

      Returns the largest integer that is less than or equal to a given numeric value.

    • Numeric logarithm

      Calculates the logarithm of a numeric value.

  • Click Common transforms. The following common transforming options are available:
    • To clean up white spaces in a string, use the following functions:
      • Trim leading and trailing white spaces

        Trims white spaces at both the beginning and end of a string.

      • Collapse consecutive white spaces

        Collapses consecutive white spaces into a single white space.

      • Convert empty string to null

        Converts empty string to null.

      • Convert null to empty string

        Convert null values to empty strings.

    • To replace special characters with HTML entities, use the following function:
      • Unescape HTML entities

      Occasionally, your data exported from a web application might 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 in a column, use the following function:
      • Blank out cells