Mirth Community

Mirth Community (http://www.mirthcorp.com/community/forums/index.php)
-   Support (http://www.mirthcorp.com/community/forums/forumdisplay.php?f=6)
-   -   "batch" process a delimited text file (http://www.mirthcorp.com/community/forums/showthread.php?t=217053)

zhuang 03-30-2017 02:48 AM

"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


All times are GMT -8. The time now is 10:56 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation