Skip to Content
0
Aug 25, 2011 at 02:12 PM

File Content Conversion help

14 Views

I have posted a question a few days back, but I now have a different problem in file content conversion.

My source XML is as below:

<?xml version="1.0" encoding="UTF-8" ?>

http://test.co.uk">

<REPORT>

<company_number>0000043239</company_number>

<transaction_type>CREATE</transaction_type>

<transaction_date>2011/08/21</transaction_date>

<sales_data>Partners (((119006.258 169077.102), (372718.323 77854.466, 371449.872 70783.383), (382225.17 73214.976, 398410.463 95156.636)))</Partners>

</REPORT>

</ns1:MT_test>

I am using the parameters as below:

Recordset Structure: REPORT

Name: REPORT.addHeaderLine Value: 3

Name: REPORT.headerLine Value: company_number,transaction_type,transaction_date,sales_data

Name: REPORT.fieldSeparator Value: ,

and I am getting the result as below which is good except that now I want the field sales_data to be enclosed between double quotes (") as below:

company_number,transaction_type,transaction_date,sales_data

0000043239,CREATE,2011/08/21,Partners (((119006.258 169077.102), (372718.323 77854.466, 371449.872 70783.383), 382225.17 73214.976, 398410.463 95156.636)))

But I want file like this: (quotes at the beginning and end of one particular field)

company_number,transaction_type,transaction_date,sales_data

0000043239,CREATE,2011/08/21,"Partners (((119006.258 169077.102), (372718.323 77854.466, 371449.872 70783.383), 382225.17 73214.976, 398410.463 95156.636)))"

What should I add?

Thanks in advance.

Thank you.