on 07-17-2014 2:22 PM
Hi all,
My source xml is:
node1_mt
<node2>
<node3> 0 to u
field1
field2
field3
<node4> 0 to u
fielda
fieldb
fieldc
</node4>
</node3>
fieldaa
fieldbb
My target file should be: (csv)
field1 field2 field3
fielda fieldb fieldc
fielda fieldb fieldc
...
fielda fieldb fieldc
How should I have my FCC parameters please?
Many thanks.
Ramesh.
Hi experts,
Any ideas please?
How to separate the item line from my header for the first item line in the target csv file?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am giving my recordset structure as:
Recordset Structure: node2,node3,node4
node2.fieldSeparator = ,
node3.fieldSeparator = ,
node4.beginSeparator = 'nl'
node4.fieldSeparator = ,
node4.endSeparator = 'nl'
and it is not producing the desired result.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ok, now got a bit further.
I am just using:
Recordset structure: header,item
header.addHeaderLine = 1
header.fieldSeparator = ,
header.endSeparator = 'nl'
item.fieldSeparator = ,
item.endSeparator = 'nl'
This is creating the output file as: (for multiple items)
field1 field2 field3 fielda fieldb fieldc
fielda fieldb fieldc
fielda fieldb fieldc
Now my only question is how can I take the first item line and put it in a separate line instead of the header? like...
field1 field2 field3
fielda fieldb fieldc
fielda fieldb fieldc
fielda fieldb fieldc
Many thanks.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.