1 Reply Latest reply: Apr 13, 2012 1:32 PM by soa_adf RSS

    File Adapter not able to read quotes after pipe

    493055
      I have flat file delimited by pipe |, and optionally enclosed by " quot, below is the xsd definition


      "<xsd:element name="vtext" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="|" nxsd:quotedBy="&quot;"/>"

      <Field Before>|"TRANS" IN TRANS FAT SHOULD APPEAR IN ITALICS MH|<FieldAfter>

      the file adapter fails to read |", but if I put a space between them, all works well. But, if it is continuous it fails to read resulting in an error.

      any help in reading such a string in nxsd would be of great help..

      thanks,
      Shailesh
        • 1. Re: File Adapter not able to read quotes after pipe
          soa_adf
          Can you please give us a before and after?

          I am guessing you want to read the text with the pipes?

          If thats the case try this:

          "<xsd:element name='element1' type='xsd:string'
          nxsd:style='surrounded' nxsd:surroundedBy='|' /> "

          Replace the single ticks with double ticks. For some reason it does not display well in the forum.

          Edited by: soa_adf on Apr 13, 2012 11:29 AM

          Edited by: soa_adf on Apr 13, 2012 11:29 AM