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.  Need help parsing data

    Employee
    Posted 01-28-2013 11:22

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

    Originally posted by: ltolleson

    I am getting a response back from an HTTP request where ALL of the data, including the header, is in a single row/column. I would like to hear from the Community about how you would resolve this issue. I currently have a way to parse this data, but my solution is not the most elegant. I would like a single node that can parse and output the results of the data.

    Please see the attached file for the Data.
    Attachments:
    ExampleData.brn


  • 2.  RE: Need help parsing data

    Employee
    Posted 01-28-2013 11:52

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

    Originally posted by: stonysmith

    IMHO, the HTTP node needs to have the option to return multiple records from the input - split at the newline character.


  • 3.  RE: Need help parsing data

    Employee
    Posted 02-06-2013 16:25

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

    Originally posted by: rpigneri

    Hey, Larry,

    So, it sounds like you are getting back a CSV file form an HTTP request, right? While I'm sure you are aware that a few Filters and an Output Delimited Node would do the trick, you are right that there should be a better answer. We will soon be releasing an "Output Raw" node that can take files stored as fields, such as the CSV in your example, and write them straight to disk. You can then read back in these files using our standard Acquisition nodes (CSV, Delimited, XML, Excel, etc.).

    Hope that answers your question.

    Rocco