Skip to Content
0
Oct 19, 2011 at 02:43 PM

B1iF : SQL to file text problem

256 Views

Hi,

I've created a business package that generate hourly a file with all new and updated items.

The file is column separated. I've defined a xml file rule as follow

<FileOutbound>
- <segment id=&quot;Produit&quot;>
  <field id=&quot;CodeProduit&quot; from=&quot;1&quot; len=&quot;6&quot; default=&quot;&quot; justify=&quot;L&quot; fillchar=&quot;&quot; /> .... 

Everything works like a charm, but the output file is wrong. The colums are well sized, but separated with comma.

Where does this comma come from ?

When I look at the full xml message, i see the following line in the header :

<Outbound type=&quot;Flat File&quot; channel=&quot;OUT_FILE&quot; format=&quot;txt&quot; fmode=&quot;write&quot; fname=&quot;D:\SAP\Echanges\Tests\TestsArticles\articles????.txt&quot; encoding=&quot;ISO-8859-1&quot; ruledoc=&quot;struct_article.xml&quot; deli=&quot;,&quot; wrap=&quot;&quot; dellead=&quot;0&quot; />

the format is txt, so the deli shoud be ignored ?

Please help !