Issue while creating new file from two files..

mishra.hanu@yahoo.co.in

• October 06, 2008 00:00

• Answered

Follow

Hi,
I have two file of two diffrent months..i want to reconcile both the file swhich are having same metadta....

say for example

articles_102.csv and articles_103.csv..

now i want to create a new file wich having records present in both..this is i ma able to do by intersection component.....

but my issue is that whiel i creatde new file it automatically removed all the double quotes in from the data..

say :-

orginal file hqaving data..

"123","Helloo"

and new generated file having data

123,Helloo

i those double quotes as well..

so please suggest me how should i handle that scenerio/..
It is very critical for me..


Thanks,
hanuman

• 

  avackova

  • December 07, 2009 11:38

  0

  Comment actions Permalink

  Hello,
  if you can join data with quotation marks, the easier way to not strip them is to set quotedStrings=false on the Data Reader. But if you need only data (without the quotation marks) for joining, you can use Structure Writer with mask=""$field1","$field2"" for writing data back to file.

Please sign in to leave a comment.