Commander Does Not Handle ", In Variables 关注

0
Avatar
Legacy Poster

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?

1 评论

0
Avatar
Ian Cummings
版主
评论操作 固定链接

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> 

请先登录再写评论。