title: Removing Comma from .csv column field and import to db
body: <p>The below class will import the .csv into database table.it is working fine.
  But when, it come across the numeric values like this 2,345. It result in error.</p>
  
  <p>In my .csv files there are 3 columns like this:</p>
  
  <p>Datatypes for these columns in db2 table "COMPUTER" is  COL_A(VArchar 50), COL_B(Double), COL_C(Varchar 50)</p>
  
  <p>COL_A                          |           COL_B                             |     COL_C</p>
  
  <hr>
  
  <p>KKGG56                          |       7,567                                |     JUNE2013</p>
  
  <p>GGHHK2                          |       259,024                              |     MAY 2012</p>
  
  <p>So, how to remove the these comma from the particular column while importing into the db table and where to place the code in my program?  Please help.</p>
  
  <pre><code>public class CSVLoader {
  
  private static final 
      String SQL_INSERT = "INSERT INTO OPM.${table}
           (${keys})      VALUES(${values})";
  
  private static final String TABLE_REGEX = "\\$\\{table\\}";
  
  private static final String KEYS_REGEX = "\\$\\{keys\\}";
  
  private static final String VALUES_REGEX = "\\$\\{values\\}";
  
  private Connection connection;
  
  private char seprator;
  
  public CSVLoader(Connection connection) {
  
      this.connection = connection;
  
      //Set default separator
  
      this.seprator = ',';
  }
  
        public void loadCSV(String csvFile, String tableName) throws Exception {
  
      CSVReader csvReader = null;
  
      if(null == this.connection) {
  
          throw new Exception("Not a valid connection.");
      }
  
      try {
  
          csvReader = new CSVReader(new FileReader(csvFile), this.seprator);
  
      } catch (Exception e) {
  
          e.printStackTrace();
  
          throw new Exception("Error occured while executing file. "
  
                     + e.getMessage());
  
                }
  
          String[] headerRow = csvReader.readNext();
  
      if (null == headerRow) {
  
          throw new FileNotFoundException(
  
  
                          "No columns defined in given CSV file." +
  
                           "Please check the CSV file format.");
      }
  
      String questionmarks = StringUtils.repeat("?,", headerRow.length);
  
      questionmarks = (String) questionmarks.subSequence(0, questionmarks
  
              .length() - 1);
  
  
      String query = SQL_INSERT.replaceFirst(TABLE_REGEX, tableName);
  
      query = query
              .replaceFirst(KEYS_REGEX, StringUtils.join
  
               (headerRow,   ","));
  
      query = query.replaceFirst(VALUES_REGEX, questionmarks);
  
              System.out.println("Query: " + query);
  
      String[] nextLine;
  
      Connection con = null;
  
      PreparedStatement ps = null;
  
      try {
          con = this.connection;
  
          con.setAutoCommit(false);
  
          ps = con.prepareStatement(query);
  
                         final int batchSize = 1000;
  
                       int count = 0;
  
          Date date = null;
  
          while ((nextLine = csvReader.readNext()) != null) {
  
              System.out.println( "inside while" );
  
              if (null != nextLine) {
  
                  int index = 1;
  
                  for (String string : nextLine) {
  
                      date = DateUtil.convertToDate(string);
  
          if (null != date) {
  
                      ps.setDate(index++, new java.sql.Date(date
  
                      .getTime()));
  
                       } else {
  
                    ps.setString(index++, string);
  
      System.out.println( "string" +string);
  
                      }
  
                  }
  
                  ps.addBatch();
  
              }
  
              if (++count % batchSize == 0) {
  
                  ps.executeBatch();
  
              }
  
                       }
  
  
          ps.executeBatch(); // insert remaining records
  
          con.commit();
  
      } catch (Exception e) {
  
          con.rollback();
  
          e.printStackTrace();
  
          throw new Exception(
  
          "Error occured while loading data 
  
                  from file                to                      database."
  
                 + e.getMessage());
  
      } finally {
  
               if (null != ps)
  
  
              ps.close();
  
          if (null != con)
  
              con.close();
  
              System.out.println("csvReader will be closed");
  
          csvReader.close();
  
      }
  
  }
  
  public char getSeprator() {
  
      return seprator;
  
  }
  
  public void setSeprator(char seprator) {
  
      this.seprator = seprator;
  
  }
  
  
           }
  </code></pre>