Clovertech

FRL – Multiline records

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › FRL – Multiline records

  • Creator
    Topic
  • October 29, 2015 at 7:32 pm #54868
    Dustin Sayes
    Participant

      I have an inbound FRL, that uses multiple lines per record. i need to combine the 7 lines into a single line so that it can be read like a normal, in line FRL.

      Each record will start with a static value like “REC1”.

      REC1 some data

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • October 29, 2015 at 10:10 pm #83272
        Jim Kosloskey
        Participant

          Have you given any thought to defining the file as an HRL with repeating FRL where the first field is equal to ‘REC1’?

          I have done that with VRL and I don’t see why it could not work with FRL.

          email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

        • October 30, 2015 at 4:18 pm #83273
          Dustin Sayes
          Participant

            Hey Jim, thanks for the post.

            I’m not sure I follow you. I do see how to repeat an FRL in an HRL. Only the first line starts with “REC1” the next seven lines after it, don’t start with REC1 and each line has a different layout.

          • October 30, 2015 at 4:40 pm #83274
            Jim Kosloskey
            Participant

              Dustin,

              OK I did not understand the whole situation I guess.

              I thought all of the detail records started with REC1 – are you saying the actual record is physically broken into multiples?

              email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

            • October 30, 2015 at 5:15 pm #83275
              Dustin Sayes
              Participant

                Correct, each record is broken into multiple lines: Here is a sample. I anomized some data for HIPAA.

                Where stringrange 0 3 = REC1 is beginning of a new record.

                Note below there are two layouts. Apparently there is a value at position 14-20 that indicates which layout is being used. I dont have all the details on that yet but I figure if I could just turn this into a single line record, that would be a good start…

                _______________________________________________________________

                REC1810393215GREMP  NONE

                                                                                       0                      0         12121212    SIM          HC

                03/28/201507/31/20158362 7JOSEPH, DUSTIN SAYES

                                                                                                         INPDH641  000  000  000 #EOL#

                REC1810393215PTADD  FOREST                              TREES

                PO BOX 177                         SAINT MISO             AL 36568

                SAINT MISO                    NY75035                                   2519570947  09/15/1901M424562196 12121212    SIM          HC

                03/28/201507/31/20158362 7JOSEPH, DUSTIN SAYES

                                                                                                         INPDH641  000  000  000 #EOL#

                REC1810393215PTEMP  NONE

                                                                                       0                      0         12121212    SIM          HC

                03/28/201507/31/20158362 7JOSEPH, DUSTIN SAYES

                                                                                                         INPDH641  000  000  000 #EOL#

                REC1810393215PTGARS FOREST                              TREES

                PO BOX 177                         SAINT MISO             AL 36568

                SAINT MISO                    NY75035                                   2519570947  09/15/1901M424562196 12121212    SIM          HC

                03/28/201507/31/20158362 7JOSEPH, DUSTIN SAYES

                                                                                                         INPDH641  000  000  000 #EOL#

                REC1810393215SEH64  RETIRED

                                                                                       0                      0         12121212    SIM          HC

                03/28/201507/31/20158362 7JOSEPH, DUSTIN SAYES

                                                                                                         INPDH641  000  000  000 #EOL#

                REC1810393215SSH6401FOREST                              TREES

                PO BOX 177                         SAINT MISO             AL 36568

                SAINT MISO                    NY75035                                   0           09/15/1901M424562196 12121212    SIM          HC

                03/28/201507/31/20158362 7JOSEPH, DUSTIN SAYES

                __________________________________________________________________

              • October 30, 2015 at 5:18 pm #83276
                Jim Kosloskey
                Participant

                  I have a proc which may be of use to you.

                  Email me and we can discuss this off line.

                  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

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