Thread: csv or text file to Multiple csv or text file

Have to write Java code to Select CSV File or Text file from Computer and Split into multiple files.. based on field information.. Split file by State

Please help me!!

Example:

robert.txt select this file..

FirstName,LastName,Address1,Address2,City,State,Zi p
robert,paul,windihill,,fort myers,FL,30907
rathin,das,oakbook,apt:2453,fort myers,FL,30907
Joshua,Arem,160 Crestwood Ct,,Alpharetta,GA,30067
Soak,Yang,1335 Kilmington Ct,,Alpharetta,GA,30009
Zerita,Washington,845 Regal Path Ln,Decatur,TN,30087
Zerita,Washington,845 Regal Path Ln,Decatur,TN,30004
......
.......
......
....

Split files..

1) robert_state_FL

FirstName,LastName,Address1,Address2,City,State,Zi p
robert,paul,windihill,,fort myers,FL,30907
rathin,das,oakbook,apt:2453,fort myers,FL,30907

2) robert_state_GA

FirstName,LastName,Address1,Address2,City,State,Zi p
Joshua,Arem,160 Crestwood Ct,,Alpharetta,GA,30067
Soak,Yang,1335 Kilmington Ct,,Alpharetta,GA,30009

3) robert_state_TN

FirstName,LastName,Address1,Address2,City,State,Zi p
Zerita,Washington,845 Regal Path Ln,Decatur,TN,30087
Zerita,Washington,845 Regal Path Ln,Decatur,TN,30004

...
...
--------------------
Trying to do this!!

 
package com.mkyong.io;
import javax.swing.JFileChooser;
import javax.swing.filechooser.FileNameExtensionFilter;
 
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
 
public class split {
 
	public static void main(String[] args)throws Exception {
 
		JFileChooser chooser = new JFileChooser();
		FileNameExtensionFilter filter = new FileNameExtensionFilter ("Text/Java files", "txt", "java");
		chooser.setFileFilter(filter);
 
		int returnVal = chooser.showOpenDialog(null);
 
		if(returnVal == JFileChooser.APPROVE_OPTION) {
			File f = chooser.getSelectedFile();
			BufferedReader br = new BufferedReader (new FileReader(f));
			String st = "";
			while((st = br.readLine()) != null) {
				System.out.println(st);
			}
 
		}
 
	}
 
}

I know how to choose text file from computer and read that.. but.. I don't know next please help me..

Thank you for you replay..

Program suppose to do..

1) select text file
2) read that.. look for State field and count that how many times state changed..
3) make csv or text files.. that many times as state changed..
4) name that.. filename_state_statename.txt or csv
5) first line is same in every text file
6) import data into files..

Agree with you man, so you want me do one step at a time..
I mean i didn't understand second part thing is which command i need to use .. which is better?? to just look over state field and create that many times text file or csv file.. as state changed..

6) i m sorry import mean split data into files....

ohh ok thanks i will do that.. do you and link that.. i can read all the commands so i can put that into code.. because i did't know that also.. lol

which one is better array it good idea to use?? split(,)

so what you suggest me to use to look over state field??

no its not always located next to last column.. but its always in text file or csv file.. so we have to find.. state from file.. because i don't where it located.. soo.. what i can use??

Its always 2 letters soo...what you want me to use for that?/

Actually we can do with fully state name.. how can i do that?? that's fine..because sometimes its come with fully state names..

its always come with state name like georgia, florida... fully names