Subject:How to add a value when converting a csv file to xml Author:gaston zajdman Date:26 Feb 2013 03:49 PM
Hi, I'm converting a csv file to xml, this file has many solutions, for each solution I need to add at the beginning <statement> and at the end </statement>, below is an example, can someone guide me on how to do this?
Subject:How to add a value when converting a csv file to xml Author:gaston zajdman Date:27 Feb 2013 10:40 AM Originally Posted: 27 Feb 2013 10:39 AM
Thanks for the reply but your solution is putting <statement> at the beginning and at the end of the document, I need to have these at the beginning and end of each solution and I have 4 solutions per record, below is an example of what the conversion looks like when I open it in stylus, in my file I have a column for statement at the start and at the end of each solution, the conversion does it but since these columns in my file are blank it alwasy does </statement>, I need to know if it is possible to somehow put <statement> at the beginning of the statement and </statement> at the end of the statement.
<statement/>
<statement_type>Keywords</statement_type>
<statement_distribution>External</statement_distribution>
<content_type>HTML with AutoLinks</content_type>
<summary>Test Keywords1</summary>
<detail/>
<statement/>
<statement/>
<statement_type>Symptom</statement_type>
<statement_distribution>External</statement_distribution>
<content_type>HTML with AutoLinks</content_type>
<summary>.</summary>
<detail>Test Symptom1</detail>
<statement/>