Commander Does Not Handle ", In Variables

Legacy Poster

• 6. August 2014 23:13

When I have text that has ", in it, when commander transforms it to BTXML, the Cdata has too many data fields, and not enough headers.  Is there a way to use a different delimiter or escape the comma or double quote, so the field doesn't get split?

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • 7. August 2014 13:31

  Use the <Delimitation> and <FieldDelimiter> tags to specify a custom field delimiter.  See the below example.

  <?xml version="1.0" encoding="utf-8"?> 
  <XMLScript Version="2.0" Name="09232006_103601_Job1" ID="123">
  <Command Name="Job1">
  <Print> 
  <Format>Label1.btw</Format>
  <RecordSet Name="Text File 1" Type="btTextFile">
  <FileName>Data1.dat</FileName>
  <Delimitation>btDelimCustom</Delimitation> 
  <FieldDelimiter>;</FieldDelimiter>
  <NumberOfFields>10</NumberOfFields>
  <UseFieldNamesFromFirstRecord>true</UseFieldNamesFromFirstRecord>
  </RecordSet> 
  </Print> 
  </Command> 
  </XMLScript> 
  

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.