Databases
StackOverflow2013
Postsdbo
POPut data in one line In csv file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPut data in one line In csv file
    primarykey
    data
    text
    <p>I'm trying to write xml data into csv file. Everything is working fine except when data's length is too long then its write the data in new line.e.g if address is too long then its going to next line and then write data.</p> <pre><code>public class ExportToCSV { public static final String LINE_BREAK = "\n"; List&lt;Line&gt; lines = new ArrayList&lt;Line&gt;(); public static void main(String argv[]) { try { File fXmlFile = new File("C:/Users/Master/Desktop/demo_jar/Eff_SOR.xml"); DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance(); DocumentBuilder dBuilder = dbFactory.newDocumentBuilder(); Document doc = dBuilder.parse(fXmlFile); doc.getDocumentElement().normalize(); System.out.println("Root element :" + doc.getDocumentElement().getNodeName()); NodeList nList = doc.getElementsByTagName("record"); System.out.println("----------------------------"); List&lt; Map&lt;String, String&gt;&gt; list = new ArrayList&lt;Map&lt;String,String&gt;&gt;(); for (int temp = 0; temp &lt; nList.getLength(); temp++) { Map&lt;String, String&gt; map = new HashMap&lt;String, String&gt;(); Node nNode = nList.item(temp); if (nNode.getNodeType() == Node.ELEMENT_NODE) { Element eElement = (Element) nNode; map.put("Address", eElement.getElementsByTagName("address_").item(0).getTextContent()); map.put("Price1", eElement.getElementsByTagName("price1").item(0).getTextContent()); map.put("Base_qty1", eElement.getElementsByTagName("base_qty1").item(0).getTextContent()); map.put("base_price1", eElement.getElementsByTagName("base_price1").item(0).getTextContent()); list.add(map); } } generateCsvFile("C:\\Users\\Master\\Desktop\\demo_jar\\testCSV.csv", list ); } catch (Exception e) { e.printStackTrace(); } } private static void generateCsvFile(String sFilename, List&lt; Map&lt;String, String&gt;&gt; test) { try { FileWriter writer = new FileWriter(sFilename); writer.append("Address"); writer.append(","); writer.append("Price1"); writer.append(","); writer.append("Base_qty1"); writer.append(","); writer.append("Price2"); writer.append(","); writer.append("base_price1"); writer.append(","); writer.append(LINE_BREAK); for (Map&lt;String, String&gt; map : test) { Iterator iterator = map.entrySet().iterator(); while (iterator.hasNext()) { Map.Entry&lt;String,String&gt; mapEntry = (Map.Entry&lt;String,String&gt;) iterator.next(); //ystem.out.println("key: " + mapEntry.getKey() + ", value:" + mapEntry.getValue()); writer.append(mapEntry.getValue()); writer.append(","); iterator.remove(); } writer.append(LINE_BREAK); } writer.flush(); writer.close(); }catch(Exception e){ } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAanshi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COHow do you verify it is writing another line? Maybe you should use a good editor which you can set up not to insert linebreaks for readability, but only shows the linebreaks in the file.
      singulars
      1. POPut data in one line In csv file
      1. USMatthias
    2. COcan you print a demo string line which crosses the cell boundary
      singulars
      1. POPut data in one line In csv file
      1. USHussain Akhtar Wahid 'Ghouri'
    3. CO@Matthias I just check out the output file.If i used any editor then evrrthng is working fine but i want to do it with java only
      singulars
      1. POPut data in one line In csv file
      1. USAanshi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload