CSV in Java . . . what?

poo in the loo

>>56436962

I'm from the United States.

>>56436962

Save that stupid shit for /b/. If you don't know the answer, just say so. At least OP isn't begging us to spoonfeed him information.

Yes OP, OpenCSV will resolve this problem, but I have no idea how or why it works.

>>56436947
how many columns is going to have a row?

or its just a line per user input?

>>56437412

It's just a line. The example I showed was someone answering a related question on Stack Overflow.

I really don't want this to turn into an all day affair. :( Right now I have the OpenCSV JAR downloaded and the dependency written into my pom.xml but I'm unsure of where to go from here - or if it's even in the right classpath.

File: rotsnake.gif (303KB, 1024x768px) Image search: [Google]

303KB, 1024x768px

import com.opencsv.*;

void main(String... a){
    CSVWriter writer = new CSVWriter(new FileWriter("yofile.txt"));
    List<String> line = new ArrayList();
    
    do{
        System.out.print("input>");
        line.add(System.console().readLine());
    }while(line.size() < 3); //user inputs per line
    
    writer.writeNext(line.toArray(new String[line.size()]));
    writer.close();
}

>>56436947
Escape sequence.
By default, you add " to any user string. If the string already contains ", replace it with \". If it contains \, replace with \\.

Problem solved.

Next time go read what serialisation, XML, JSON is and how it all is already built in Java so code monkeys can actually implements what is needed instead of reinventing wheel.

Also database. Try sqlite for starters, because storing table datas in files is mostlikely retarded. Should also be build in Java.

>>56438519

So what happens when the user inputs "\\" ?

>>56439815
It becomes \\\\

>>56439855

How does this decode then?

Sorry if these are stupid questions but I'm kind of lost here.

Normally I would just not allow users to input the token as a value, but bossman says we can't do that anymore. He wants it so that the user can input whatever they want without breaking it.

I don't understand :

>By default, you add " to any user string. If the string already contains ", replace it with \". If it contains \, replace with \\.

Are you talking about using an enhanced for loop to check the output?

>>56439964
you put " " around any input so it's a string, if there are " already in the input you put \" so it uses it as a normal character and not the end of string, same for normal \, you put \\ so it uses \ as a normal character

>>56440216

Maybe this is asking too much, but can I see an example? I'm still not understanding how a user can't just break this by inputting the right characters AND allowing the program to consistently decode without changing data.

I have this right now...

   
        String printInput;
        if (userInput.contains(",")) {
            userInput = userInput.replaceAll(",", "~!~");
        }
        

        printInput = userInput;

        return printInput;

    }

.

In the decode method, it finds all incidents of ~!~ and turns them into commas.

The problem is if you write ~!~, it pretty much just turns it into a comma.

You're talking about implementing some kind of loop and I have no idea what that would even look like or how the decode would work with it.

>>56440341
basically:

String doubleQuote = Character.toString((char) 34);
String backslash = Character.toString((char) 92);

userInput = userInput.replaceAll(backslash, backslash + backslash);

userInput = userInput.replaceAll(doubleQuote, backslash + doubleQuote);

Basically the code above takes the ascii values for double quote and backslash, and casts them to chars, and then converts them to strings.

It replaces all instances of quote chars with a backslash followed by a quote, and all instances of backslashes with two backslashes in a row. (Hopefully the String.replaceAll method can do that without an infinite loop.)

When you're reading back from the file, when you encounter a backslash, just don't even check whether the next character is a quote or a backslash, just read it in verbatim.

>>56436947
A professional java programmer will find a well established library for this and import the jar into the classpath. Almost anything you need, if it isn't already in the native release can be found in an apache commons library.

https://commons.apache.org/proper/commons-lang/javadocs/api-2.6/org/apache/commons/lang/StringEscapeUtils.html

Now the C and CPP fags will sperg off, lol.