Convert table to CDS format

Value

Value

Script

BufferedReader bf = new BufferedReader(new FileReader(fileName));

int status; 
result = "";
final int INSIDE_NUMBER = 0, WAITING_FIRST_NUMBER = 1, WAITING_DIGIT = 2, INSIDE_STRING = 3; 
int i = 0;
String line;
int columnsNumber = 0;
String [] header = null;
int [] init = null;
int [] end = null;
while ((line = bf.readLine())!=null) {
    if(i==0){
        /*header*/
    	line = line.replaceFirst("#", "").replaceAll("\t", " ").trim().replaceAll(" +", " ");
    	header = line.split(" ");
    	columnsNumber = header.length;
    	init = new int[columnsNumber];
    	end  = new int[columnsNumber];
    	//for (String cad: header){
    	//	System.out.println("-"+cad+"-");
    	//}
    	
    }else{ 
    	if(i==1){
	        /*data*/
	    	int colIndex = 0;
	    	init[colIndex]=1;
	    	
	    	if(line.charAt(0)==' ')
	    		status = WAITING_FIRST_NUMBER;
	    	else
	    		status = INSIDE_NUMBER;
	    	
	    	for(int j = 0; j end[columnsNumber-1]){
	    		System.out.println("Adjust last column size from "+ end[columnsNumber-1] + " to "+ line.length());
	    		end[columnsNumber-1] = line.length();
	    	}
	    }
    }
    i++;
}


result = "Number of records: " + (i-1) + System.getProperty("line.separator");
result = result + "Columns Information: " + System.getProperty("line.separator");
for(int k = 0; k

Script

BufferedReader bf = new BufferedReader(new FileReader(fileName));

int status; 
result = "";
final int INSIDE_NUMBER = 0, WAITING_FIRST_NUMBER = 1, WAITING_DIGIT = 2, INSIDE_STRING = 3; 
int i = 0;
String line;
int columnsNumber = 0;
String [] header = null;
int [] init = null;
int [] end = null;
while ((line = bf.readLine())!=null) {
   line = line.replace("\"\"", "  ");
   result += line + System.getProperty("line.separator");
   i++;
}

Script

File file = File.createTempFile("astro_cds", null);
filePath = file.getAbsolutePath();