how to change the layout of an input file and write to an output file

**renu** · 05-12-2010, 05:04 PM

Hi

I have a .csv file which has a layout as schoolNo. , county1,county2,county3,county4,county5

It will need to go into an output file as schoolNo. repeated and a county on each record .

ie., schoolNo.,county1
schoolNo.,county2
schoolNo.,county3
schoolNo.,county4
schoolNo.,county5

I wrote the java program as follows ..which results in this error
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException
BECAUSE :--
i know bec., the first record doesnot have county3,county4,county5 . So when the if loop for county3 lenght is checked it gives this exception .

Pls help me write this program ..thanks in advance .

Java Code:

/Here I open the input file and read in record by record                                                                                                                         
		BufferedReader readin;
		try {
			readin = new BufferedReader(new FileReader(InFile));
			String firstLine = readin.readLine();
			String[] headers = firstLine.split(",");
			columnCount = headers.length;
			System.out.println("Columns in ZIP Master File: "+columnCount);
			for(String input ;(input = readin.readLine()) != null; ){
				recCount++;
				input = input.substring(1);			
				String[] column = input.split(",");
									
				if(columnCount == 10){
					eachIP++;
//						 OUTPUT FILE
  						if(column[1].length()> 0) {
							String mainStr = column[0] + "," + column[1] ;  
							Count++;
							totalcolumns++;
							writeOutFile.write(mainStr);
							writeOutFile.newLine();
						}	 
						else{
						bypassedCount++;
					    }
  						if(column[2].length()>0){
  							String mainStr = column[0]+ "," + column[2];
  							Count++;
  							totalcolumns++;
							writeOutFile.write(mainStr);
							writeOutFile.newLine();
						}	 
						else{
						bypassedCount++;
					    }
  						if(column[3].length()>0){
  							String mainStr = column[0]+ "," + column[3];
  							Count++;
  							totalcolumns++;
							writeOutFile.write(mainStr);
							writeOutFile.newLine();
						}	 
						else{
						bypassedCount++;
					    }

**r035198x** · 05-12-2010, 05:24 PM

Check the length of the column array using an if before accessing an element in the array.

**JosAH** · 05-12-2010, 05:37 PM

Crossposted.

kind regards,

Jos

**renu** · 05-12-2010, 05:38 PM

Hi

I didnot understand what you want me to do in the code i wrote.

can you pls help me , change my code .

thank you

**renu** · 05-12-2010, 05:41 PM

Originally Posted by JosAH

Crossposted.

kind regards,

Jos

Hi Jos

I thought both r different websites ..and to get a reply from each website , i have posted it .
i dont feel , i did any wrong

**JosAH** · 05-12-2010, 06:51 PM

Originally Posted by renu

Hi Jos

I thought both r different websites ..and to get a reply from each website , i have posted it .
i dont feel , i did any wrong

Don't think from yourself, think about people who may spend their time answering your question only to find out that your question has also been answered on another website before; those people have wasted their time and effort. It is just courtesy to mention the fact that you have posted your question somewhere else so people can check out both threads.

kind regards,

Jos

**renu** · 05-12-2010, 07:22 PM

Hi

The input files record looks like this
1220,10,20,,,,

Once the code comes to

if(column[3].length()>0){
String mainStr = column[0]+ "," + column[3];
Count++;
totalcolumns++;
writeOutFile.write(mainStr);
writeOutFile.newLine();
}
else{
bypassedCount++;
}

--------------------------------------------------------------------------------
Last edited by renu; Today at 03:26 PM.

i get array out of bound exception..pls help
why doesnot the array element atleast pick up null in it

**JosAH** · 05-12-2010, 07:38 PM

Originally Posted by renu

Hi

The input files record looks like this
1220,10,20,,,,

Once the code comes to

if(column[3].length()>0){
String mainStr = column[0]+ "," + column[3];
Count++;
totalcolumns++;
writeOutFile.write(mainStr);
writeOutFile.newLine();
}
else{
bypassedCount++;
}

--------------------------------------------------------------------------------
i get array out of bound exception..pls help
why doesnot the array element atleast pick up null in it

There are two split( ... ) methods; check the other one (the one with two arguments), it allows for empty entries to be counted, i.e. split(inputString, -1) gives you the wanted results.

kind regards,

Jos