web stats
Mirth Community - View Single Post - CSV Transformer Removing Quotes
View Single Post
  #1  
Old 08-22-2014, 12:19 PM
zap_me zap_me is offline
Mirth Newb
 
Join Date: Apr 2013
Posts: 10
zap_me is on a distinguished road
Default CSV Transformer Removing Quotes

Hello All,

I have a Mirth 3.0.3.7171 channel that reads a csv, queries MSSQL for patient email addresses, then writes a new csv with the queried emails. It all works with one exception... the final data file doesn't have the double quotes (") and I can't figure out where they went or how to get them back.

Here is some dummy data I have been reading:
"48","48","Abbey","Jeff"
"AETNA","379","Aetna","CapPlanOffsetAccount"
"22","22","Anderson","Lucille"
"35","35","Barton","Dana"
"677","576","Bassett","Don"

And here is the final data after Mirth transformer:
48,48,Abbey,Jeff,jabbey@aol.com
AETNA,379,Aetna,CapPlanOffsetAccount,
22,22,Anderson,Lucille,retiredlady@email.com
35,35,Barton,Dana,donna@kind.com
677,576,Bassett,Don,dbassett@aol.com

As best as I can tell my transformer javascript isn't causing this. When I remove the transformer code I am still missing the quotes. If I change the Destination Template to Raw I get the quotes back but the output doesn't include the emails. I changed all the Data Types to Delimited Text and used Default settings.

What am I missing that would allow the final, encoded, transformed data to include quotes around all the elements?

Thank you!

Last edited by zap_me; 08-22-2014 at 12:36 PM.
Reply With Quote