Extract data from CSV file

Replies

• 

  Kaustubh Katdare

  Vivek_Kumar

  Any one pls tell me how we can extract the exact data from the csv file in java

  Some more information about the number of tables in your CSV file, number of CSV files you want to process and the code that you've written so far would definitely help others provide better help to you.
• 

  Vivek_Kumar

  well I need to know that can we apply 'where' clause to fetch the data from CSV file like what we do in MYSql.
• 

  Kaustubh Katdare

  Vivek_Kumar

  well I need to know that can we apply 'where' clause to fetch the data from CSV file like what we do in MYSql.

  Share your code, please.
• 

  simplycoder

  Please do share your code, but then if don't have slightest idea how to do it,
  Follow these steps.
  
  1)Write lines of code which will read the file.
  2)Extract contents and as it is.
  3) Use split function on ',' to separate the values.
  4) And have fun with them.
• 

  Manish Goyal

  Vivek_Kumar

  well I need to know that can we apply 'where' clause to fetch the data from CSV file like what we do in MYSql.

  no, where clause applies on database where as csv is a file type, where you can only perform read or write operations or you can search certain text or string
• 

  Vivek_Kumar

  Thanks.................