web stats
"batch" process a delimited text file - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2017, 02:48 AM
zhuang zhuang is offline
Mirth Newb
 
Join Date: Aug 2016
Location: Winchester, MA
Posts: 9
zhuang is on a distinguished road
Default "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
Reply With Quote
Reply

Tags
batch process, csv, delimited, split

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 05:59 PM.


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