Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  1. Now that you have selected a specific format for your Datetime values, the rows that do not match this format are now identified as mismatched in the column. Click the red bar at the top of the column.
  2. In the Status bar at the bottom of the screen, click Show only affected rows.
  3. You can now see only the rows that remain mismatched with respect to the preferred Datetime format. 
  4. Select one of these values. For example, suppose you have quite a few values that are only four-digit year values (YYYY). Select one of the values. Then, select the Replace card. Click Edit.
  5. Your transformation should look like the following:

    D trans
    p03Value''
    Typestep
    p01NameColumn
    p01ValueUpdateTime
    p02NameFind
    p02Value`\{start\}\{digit\}\{4\}\{end\}`
    p03NameReplace with
    SearchTermReplace text or patterns

     

  6. You can modify the search and replace patterns to capture and write back the year value:
    1. In the Find value, put parentheses around the pattern that captures the four digits in a row. Adding parentheses around a matching pattern identifies that sub-pattern as a capture group, which can be referenced in any replacement.
    2. The capture group should look like the following:

      Code Block
      ({digit}{4})
    3. For the Replace with value, you must insert a month and day value according to the format selected for the column (MM/DD/YYYY), followed by a reference back to the capture group.

    4. Capture groups from the matching pattern can be referenced in the replacement value using references such as $1$2$3, and so on. These tokens refer to the first, second, and third capture groups in the Find value.
    5.  The Replace value should look like the following:

      Code Block
      01/01/$1
    6. Your transformation should look like the following when done:

      D trans
      p03Value01/01/$1
      Typestep
      p01NameColumn
      p01ValueUpdateTime
      p02NameFind
      p02Value`{start}({digit}{4}){end}`
      p03NameReplace with
      SearchTermReplace text or patterns

  7. Click Add.
  8. You can repeat these steps for the remaining mismatched values.

...