title: CSV , JAVA & HSQLDB
body: <p>im really new in java programming</p>
  
  <p>i want to ask about reading a <strong>CSV in java and then upload it to HSQLDB</strong>.
  i have been reading &amp; try the example of solution through tutorial but still not really understand.
  from my readings, <strong>most had suggest of using OpenCSV</strong> but</p>
  
  <ol>
  <li>can i read a csv with delimiter or nested delimiter with opencsv?
  <ul>
  <li>opencsv reads my *.csv file in different way with multiple line in one column. all i want it to be read in a single row.</li>
  </ul></li>
  </ol>
  
  <p>below is the example </p>
  
  <p>B03BB510001T2001,,CHILDREN'S CHEWABLE MULTI VITAMINS*,,""PANTOTHENIC ACID 7.5MG,"
  "PARA AMINO BENZOIC ACID (PABA) 250MCG,"
  "FOLIC ACID 30MCG,"
  "BIOTIN 50MCG,"
  "THIAMINE MONO-NITRATE + B6 + B12 6.6MG,"
  "CHOLINE 1MG,"
  "VIT A + VIT E + VIT C REFER FILE,"
  "INOSITOL 1MG"",,""TABLET, CHEWABLE"",,,,B03,REGISTERED,75MG"</p>
  
  <p>BUT i want it to be displayed in <strong>a single row</strong></p>
  
  <ol>
  <li>how can i insert directly from csv file into database?
  <ul>
  <li>i am currently have to used HSQLDB [standalone server].
  do i have to used third party tools to do this</li>
  </ul></li>
  </ol>
  
  <p>**i only familiar reading &amp; upload from csv into database using PHP &amp; MYSQL not java &amp;hsqldb</p>
  
  <p>hope you can suggest &amp; help me.</p>