Results 1 to 3 of 3

Thread: Delimited dataset in a workflow

  1. #1

    Default Delimited dataset in a workflow

    Is there a node that would allow me to parse data by a delimiter in the middle of a flow?

    There are some instances in which I have, let's say, a tab delimited file. But there may be some fields that are also a concatenate of multiple fields, delimited by a pipe (or something). I would like to import using the standard \t delimiter, then in the flow, add another note to either parse a specific field by a different delimiter or to parse the entire dataset by said new delimiter.

    Is this possible? And if it is...how?

    Thank you

  2. #2
    Contributor
    Join Date
    Apr 2011
    Location
    Copenhagen
    Posts
    140

    Default

    I think you could use the split function if I understand the question correctly.

    example:

    yourfield.split(";").getItem(0) as "Newfield"

  3. #3
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    226

    Default

    To expand on the example from ThomasT (thanks or contributing BTW) you may be interested in this forum thread that also covered this topic:

    http://community.lavastorm.com/threa...-Columns-ouput

    Regards,
    Adrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •