VRL with column names in the output file

Clovertech Forums Cloverleaf VRL with column names in the output file

  • Creator
    Topic
  • #119563
    Collin Praster
    Participant

      I am looking for a tcl that would put the VRL headers on the first line of the file that it is writing to.

       

      Example

      Fname   lname          email

      Collin      Praster        cpraster@kdhcd.org

       

       

    Viewing 5 reply threads
    • Author
      Replies
      • #119572
        Charlie Bursell
        Participant

          The problem you will have here is the variable width of each field and record.  How do get the fields justified under the proper headings?

        • #119573
          Collin Praster
          Participant

            They dont need to stay aligned, I think the receiving system is just using the header to input into excel and then its delimited by the pipe |

          • #119574
            Charlie Bursell
            Participant

              I don’t know how you are sending the data but it seems to me if you have control of it why not simply build a VRL record with the headers and output it first?

            • #119588
              Collin Praster
              Participant

                Hey Charles I get what you are saying but how would I go about it?

              • #119589
                Collin Praster
                Participant

                  I don’t know if this is what you were thinking but you were right I just did a  =column name and mapped it to a new vrl file but then I realized it would duplicate that every time a new value was sent over.  I would just need that header value one time not every message.

                • #119590
                  Charlie Bursell
                  Participant

                    I could not provide more as I had no idea what interfaces you are using.

                    Looks like what you did is OK just figure when to send the header.

                Viewing 5 reply threads
                • You must be logged in to reply to this topic.