web stats
Mirth Community - View Single Post - Issue setting delimiters for text file reader channel
View Single Post
  #3  
Old 06-13-2018, 07:35 AM
jmcollins jmcollins is offline
What's HL7?
 
Join Date: May 2018
Posts: 3
jmcollins is on a distinguished road
Default still not quite right, but closer to setting delimiters for text file reader channel

So we are getting closer... the delimiters table is as now set up as suggested with <48 spaces>,\n (see delimiter settings#2 below)

When I run the text document I get the below delimiter in transformed for the first record... but it still can not read the next record. (as if it's not seeing this as the delimiter.)

<delimited>
<row>
<column1/>
<column2/>
<column3/>
<column4/>
<column5/>
<column6/>
<column7/>
<column8/>
<column9/>
<column10/>
<column11/>
<column12/>
<column13/>
<column14/>
<column15/>
<column16/>
<column17/>
<column18/>
<column19/>
<column20/>
<column21/>
<column22/>
<column23/>
<column24/>
<column25/>
<column26/>
<column27/>
<column28/>
<column29/>
<column30/>
<column31/>
<column32/>
<column33/>
<column34/>
<column35/>
<column36/>
<column37/>
<column38/>
<column39/>
<column40/>
<column41/>
<column42/>
<column43/>
<column44/>
<column45/>
<column46/>
<column47/>
<column48/>
<column49>,

As a note: To get the above delimiter, I set the column delimiter to a space so I can map the unique xml segment fields to the data elements I need. If I change it to \r\n or \n the columns had many data elements in them and I couldn't parse them (pick the data elements) I need.

In any case even if I set the column delimiter to \r\n or \n it had no effect on the record or batch delimiter.
Attached Images
File Type: png delimiter settings#2.png (16.6 KB, 4 views)
Reply With Quote