Announcement

Collapse
No announcement yet.

"batch" process a delimited text file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • "batch" process a delimited text file

    Dear fellows - I would like to batch process a delimited text file. Each new "message" contain the header of the original file and each content row of the original file.

    I have trouble to figure out how to append the file header in the original file to each content row to form a two row new delimited file. I tried "source" batch configuration without success. Could someone point to me what I should do?

    The input file:

    PATIENTID LASTNAME FIRSTNAME MIDDLENAME DATEOFBIRTH GENDER ADDRESS1 ADDRESS2 CITY STATE POSTALCODE DATEADDED DATEMODIFIED ROW_MD5
    67890 Wong Amy 19810704 F 800 Mars St. Apt. 8B San Francisco CA 90045 3/28/2017 9:41:40.665041 AM 3/28/2017 9:41:40.665041 AM e214446a8e9216a42742be2118e85e03
    12121 Fry Philip J 19730901 M 1602 Washington Blvd. Apt. 20J Chicago IL 45567 3/28/2017 9:41:40.884533 AM 3/28/2017 9:41:40.884533 AM 35b84af158e12eb134d2c0744f530341
    24005 Conrad Hermes 19640202 M 13 Jamaica Place Lake Forest CA 92630 3/28/2017 9:41:41.129681 AM 3/28/2017 9:41:41.129681 AM cc925e0eaf5e2d0445c8b6af542474d7
    88670 Kroker Kif 19780606 M 800 Mars St. Apt. 8B San Francisco CA 90045 3/28/2017 9:41:41.287800 AM 3/28/2017 9:41:41.287800 AM efa9e959a336c99b4381d62ea208d298
    22811 Leela Turanga 19700501 F 6620 Olympic Blvd. Apt. 1I New York City NY 01433 3/28/2017 9:41:41.428595 AM 3/28/2017 9:41:41.428595 AM e65d5b3843e5610d173af9c8a4bef58e
    12345 Farnsworth Hubert J 19160920 M 18 Elm Dr. New York City NY 01434 3/28/2017 9:41:40.492164 AM 3/28/2017 9:41:40.492164 AM c8868892618a4a19942027122c14c9de
Working...
X