Clovertech

Headers a CSV file

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Headers a CSV file

  • Creator
    Topic
  • March 16, 2014 at 6:54 am #54102
    shikher arya1
    Participant

      Hi,

      I want to make a CSV file with Headers using VRL in Cloverleaf.

      For Ex-

      FirstName, LastName, Age, City

      Allen, Volpe, 43, NewJersey

      I tried using tagged field by modifying the Global Properties of VRL but the output came like this:

      FirstNameAllen, LastNameVolpe, Age43, CityNewJersey

      Kindly suggest!!

      Thanks

    • Creator
      Topic
    Viewing 0 reply threads
    • Author
      Replies
      • March 18, 2014 at 4:25 pm #80169
        Robert Kersemakers
        Participant

          Several ways to do this:

          * If your incoming message/file contains a header record as well, you can use that record to send your own header.

          * Maybe you can determine when the first actual record is being received/processed and send a header record before that first actual record.

          * If this csv file is processed at certain regular times, you can copy a file with only the header record as the receiving csv file. Then Cloverleaf will add all the actual records to this file.

          * First process all your actual records and put them in a csv file. Then at a certain time, another Cloverleaf process takes this file and adds a header to it. You can do this with a tcl-proc.

          It all depends on your input and your needs which option is best.

          Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

      • Author
        Replies
      Viewing 0 reply threads
      • The forum ‘Cloverleaf’ is closed to new topics and replies.