Removing blank spaces

[prad]

Hello,
Following is a part of java program.
I am reading Result Set returned by Stored Procedure in db2 and writing that into a file.
I have used DataOutputStream dos to write read object into file.

int totRows = 0;
System.out.println("Result Set"+(count-1)+" Writing into file...");
while (rs.next()) {
totRows++;
for (int i = 1; i <= col; i++) {
Object o = rs.getObject( i);
dos.writeChars(String.valueOf(o));
dos.writeUTF("\t");
}
dos.writeUTF("\r\n");
}
System.out.println(totRows+" rows written...");


Output is : File contents r like
T A B L E N A M E T A B L E C O U N T
C U S T O M E R I N F O T A B L E 6666
........
......
n so on


I want it to look like
TABLENAME TABLECOUNT
CUSTOMERINFOTABLE 6666
.............

Expect to get some help atleast this time!

[r035198x]

Hello,
Following is a part of java program.
I am reading Result Set returned by Stored Procedure in db2 and writing that into a file.
I have used DataOutputStream dos to write read object into file.

int totRows = 0;
System.out.println("Result Set"+(count-1)+" Writing into file...");
while (rs.next()) {
totRows++;
for (int i = 1; i <= col; i++) {
Object o = rs.getObject( i);
dos.writeChars(String.valueOf(o));
dos.writeUTF("\t");
}
dos.writeUTF("\r\n");
}
System.out.println(totRows+" rows written...");


Output is : File contents r like
T A B L E N A M E T A B L E C O U N T
C U S T O M E R I N F O T A B L E 6666
........
......
n so on


I want it to look like
TABLENAME TABLECOUNT
CUSTOMERINFOTABLE 6666
.............

Expect to get some help atleast this time!

I do not think the problem is caused by the writeChars method but rather the String.valueOf for your objects is the one that is putting in the spaces. (It does not seem to be happening for numbers?). You may need to split the output first:

String [] s = o.toString().split(" ");
String output = "";
for(String i: s) {
output += i;
}
dos.writeChars(output);

Or maybe you can try to look at your toString method

[prad]

Hi,
Thanx for the solution!
Its working properly for strings... but not for numbers...
can u tel me y so?wat can be done 4 dat?

[r035198x]

Hi,
Thanx for the solution!
Its working properly for strings... but not for numbers...
can u tel me y so?wat can be done 4 dat?

What is happening for the numbers?

[prad]

Its gvg smthing like this....
here CARD is first column n remaining is a number field
t CARDw8 sr java.lang.Long;‹ä�Ì�#ß
J valuexr java.lang.Number†¬•”à‹ xp
H€w< 

[r035198x]

Its gvg smthing like this....
here CARD is first column n remaining is a number field
t CARDw8 sr java.lang.Long;‹ä�Ì�#ß
J valuexr java.lang.Number†¬•”à‹ xp
H€w< 

What happens of you change String.valueOf(o) instead of o.toString()

[CodeMan007]

I do not think the problem is caused by the writeChars method but rather the String.valueOf for your objects is the one that is putting in the spaces. (It does not seem to be happening for numbers?). You may need to split the output first:

String [] s = o.toString().split(" ");
String output = "";
for(String i: s) {
output += i;
}
dos.writeChars(output);

Or maybe you can try to look at your toString method

Dont u think there is an error in the code that u proposed

for(String i: s)
the colon between String i and s
at least its not working for me...nor do i know what that means..!!

[r035198x]

Dont u think there is an error in the code that u proposed

for(String i: s)
the colon between String i and s
at least its not working for me...nor do i know what that means..!!

Certainly looks strange doesn't it? Well it's not an error but it's the new for loop format added to jdk 1.5. That code will only work for 1.5 and higher compilers. Visit sun.com to get the other additions brought into 1.5 and 1.6

[gustaverikoberg]

I am having a similar problem. There is function that is called String.getBytes()
that is said to remedy the problem of blank spaces.
Here is an example from Ivor Hortons Beginning Java (10 ed)

import java.io.*;
import java.nio.channels.*;
import java.nio.*;//det här är inte som i exemplet
 
public class WriteAStringAsBytes {
 
    /**
     * @param args
     */
    public static void main(String[] args) {
        System.out.println("Writing...");
        // TODO Auto-generated method stub
        String phrase = new String("Garbage in, garbage out\n");
        //String dirname = "C:/Skrivna filer/Bokstavsdata";
        String dirname = "c:/Skrivna filer";
        String filename = "byteData.txt";
 
        File aFile = new File(dirname, filename);
        //Create the file output stream
        FileOutputStream file = null;
        try{
            file = new FileOutputStream(aFile, true);
        }catch(FileNotFoundException e){
            e.printStackTrace(System.err);
        }
        FileChannel outChannel = file.getChannel();
        ByteBuffer buf = ByteBuffer.allocate(phrase.length());
        byte[] bytes = phrase.getBytes();
 
        buf.put(bytes);
        buf.flip();
        try{
            outChannel.write(buf);
            file.close();
            System.out.println("It has been written.");
        }catch(IOException e){
            e.printStackTrace(System.err);
        }
    }
}
 

[JosAH]

Expect to get some help atleast this time!

Don't use a DataOutputStream for that if you want just readable text. A DataOutputStream
writes Strings as they are: two bytes and for ASCII characters one of those bytes
will be 0x00 (zero). DataOutputStreams are not for producing text, i.e. they produce
raw data.

kind regards,

Jos

[gustaverikoberg]

Good tip about the output stream.
I have been working on some code and solved my problem (maybe in a not so smart way, my exam and line of proffession is in population studies) with the empty s p a c es , so if anyone would be helped here is the code:

public void writeArray()
    {
        Individual I = null;
        String dirname = "C:/Skrivna filer/Bokstavsdata";
        String filename = "proverbs2.txt";
        String[]sayings = new String[model.individualList.size() + 1];//+1 om det ska få plats variabelnamn
        String[][] values = new String[model.individualList.size()][Individual.class.getFields().length];
        Field[] fields= Individual.class.getFields();
        String variableNames = "";
        System.out.println(fields[0].getModifiers());
        int j = 0;
        Field field = null;
 
        for(int i = 0;i<Individual.class.getFields().length;i++)
        {
            field = fields[i];
            if(!(Modifier.isFinal(fields[i].getModifiers())||fields[i].isEnumConstant()||(!fields[i].getGenericType().toString().contains("double")
                    &&!fields[i].getGenericType().toString().contains("int"))))
            {
                values[0][j]=fields[i].getName();
                variableNames = variableNames.concat(values[0][j].concat(","));//for some reason skipping "variableNames =" does not work
                j++;
            }    
        }
        System.out.println(variableNames.substring(0,variableNames.length()-1));
        sayings[0]=variableNames.substring(0,variableNames.length()-1).concat(System.getProperty("line.separator"));
        String valuesToStore="";
        Object o = null;
        for(int i = 0; i<model.individualList.size(); i++)
        {
            valuesToStore="";
            I = model.individualList.get(i);
            o = (Object)I;
            o.getClass();
            int j3 = 0;
            for(int j2 = 0;j2<fields.length;j2++)
            {
 
                if(!(Modifier.isFinal(fields[j2].getModifiers())||fields[j2].isEnumConstant()||(!fields[j2].getGenericType().toString().contains("double")
                        &&!fields[j2].getGenericType().toString().contains("int"))))
                {
 
                    values[i][j3]="" + OLSRegressionCalc.sendNumber(o,fields[j2].getName());
 
 
 
                    valuesToStore = valuesToStore.concat(values[i][j3].concat(","));
                    j3++;
                }
            }
            //sayings[i+1] = year + "," + age + System.getProperty("line.separator");
            sayings[i+1]=valuesToStore + System.getProperty("line.separator");
 
        }
 
        File aFile = new File(dirname, filename);//Skapar filobjektet i Javaprogrammet
 
        FileOutputStream outputFile = null;
        try{
            outputFile = new FileOutputStream(aFile, true);//Skapar själva filen
        }catch(FileNotFoundException e){
            e.printStackTrace(System.err);
            System.exit(1);
        }
        FileChannel outChannel = outputFile.getChannel();
        int maxLength = 0;
 
        for(String saying: sayings)
        {
            if(maxLength < saying.length())
                maxLength = saying.length();
        }
        ByteBuffer buf = ByteBuffer.allocate(2*maxLength + 4);
        int i = 0;
        try{
            for(String saying: sayings)
            {
                byte[] bytes = sayings[i].getBytes();
 
                buf.put(bytes);
                buf.flip();
                outChannel.write(buf);
                buf.clear();
                i++;
            }
            outputFile.close();
            System.out.println("Proverbs written to file");
        }catch(IOException e){
            e.printStackTrace(System.err);
            System.exit(1);
        }
        //System.exit(0);
 
    }