LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Using Delimiters is a single field's records to redistribute records into new fields

    Employee
    Posted 09-16-2010 17:49

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Iain Sanders

    Subject: Using Delimiters is a single field's records to redistribute records into new fields

    Hi There,

    I have 'chains' of values with delimiter characters "__za_" (the chains) to split each record within a single field into multiple fields.

    Please advise how to do this.

    Many thanks,

    Iain


  • 2.  RE: Using Delimiters is a single field's records to redistribute records into new fields

    Employee
    Posted 09-19-2010 18:52

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: shaunmbg

    This can be achieved using the split command, then outputting the resulting list as individual fields.

    Eg

    fields = split (input, delimiter)
    emit fields[0] as field1
    emit fields[1] as field2
    etc