text qualifier

oldforum

• July 16, 2007 00:00

• Answered

Follow

Hello,
I'd like to unload data into a flat file. Every column with text content has to be wrapped by a text qualifier (e.g. double quotes).
How can I configure the "DELIMITED_DATA_WRITER" component or the "FIXLEN_DATA_WRITER" component to fulfill that requirement?
Regards,
Carsten

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Hello,
  
  if you want change a value, it is better to use Reformat component:
  
  <Node id="REFORMAT0" type="REFORMAT">
  <attr name="transform">//#TL
  function transform(){
  $0.FieldX:="\"" + $RecordName.FieldX + "\"";
  }</attr>
  </Node>
  
  You can also use STRUCTURE_WRITER, this is only one, anoter writers don't allow it:
  
  <Node fileURL="etc.out" id="STRUCTURE_WRITER" type="STRUCTURE_WRITER" mask=""$Field2" "/>

Please sign in to leave a comment.