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

...

  • The Message value for the first row of data contains carriage returns, which must be captured in the data value and not used to split the row.
  • The Message value for thughes is a single unquoted value.

TransformTransformation:

When the data is first loaded into the Transformer page, the following step is added as the first step to the recipe:

d-

...

trans
RawWrangletrue
p03Value'\"'
Typestep
WrangleTextsplitrows col: column1 on: '\r' quote: '\"'
This transform
p01NameColumn
p01Valuecolumn1
p02NameSplit on
p02Value'\r'
p03NameQuote escape character
SearchTermSplit into rows

This transformation splits the unstructured CSV data on the carriage return. However, values that are stored between double quotes are treated as single strings, and no row breaks are applied to this data. 

...