...
- Select the first quote mark in one of the entries.
- In the suggestion cards, select the Replace card.
Select the variant that deletes all quotes in the column.
The full command should look like the following:
D trans p03Value '' Type step p01Name Column p01Value Height_ft p02Name Find p02Value `"` p03Name Replace with p04Value true p04Name Match all occurrences SearchTerm Replace text or patterns - Add it to your recipe.
- 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.
- Select the single quote mark, and choose the Split suggestion card. This transformation step should split the column into two columns:
Height_ft1
andHeight_ft2
. Derive the value in inches:
D trans p03Value Height_in Type step p01Name Formula type p01Value Single row formula p02Name Formula p02Value ((Height_ft1 *12)+Height_ft2) p03Name New column name SearchTerm New formula - You can drop can delete the other, interim columns.
...