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. Select the first quote mark in one of the entries. 
  2. In the suggestion cards, select the Replace card.
  3. Select the variant that deletes all quotes in the column. 

  4. The full command should look like the following:

    D trans
    p03Value''
    Typestep
    p01NameColumn
    p01ValueHeight_ft
    p02NameFind
    p02Value`"`
    p03NameReplace with
    p04Valuetrue
    p04NameMatch all occurrences
    SearchTermReplace text or patterns

  5. Add it to your recipe.
  6. The remaining steps compute the number of inches. Multiply the feet by 12, and then add the number of inches, using new columns of data.
  7. Select the single quote mark, and choose the Split suggestion card. This transformation step should split the column into two columns: Height_ft1 and Height_ft2
  8. Derive the value in inches:

    D trans
    p03ValueHeight_in
    Typestep
    p01NameFormula type
    p01ValueSingle row formula
    p02NameFormula
    p02Value((Height_ft1 *12)+Height_ft2)
    p03NameNew column name
    SearchTermNew formula

  9. You can drop can delete the other, interim columns.

...