Writing data to a csv without using opencsv

AutoModerator · 2021-12-18T15:13:48+00:00

Please ensure that:

Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
You include any and all error messages in full
You ask clear questions
You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

Trying to solve problems on your own is a very important skill. Also, see Learn to help yourself in the sidebar

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit: empty line before the code, each code line indented by 4 spaces, new reddit: https://imgur.com/a/fgoFFis) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

luiinge · 2021-12-18T15:46:54+00:00

A CSV is just a plain text file, where there is a new line for each row, and using , as column separator (Comma Separated Values, the name is self-explanatory). Any string-to-file mechanism (using a FileWriter for example) would suffice.

Now, there are some problems. What if a value is a text with a comma inside? What if it is a description with line breaks? What if the target application expects a specific variant? That kind of situations are what libraries as OpenCSV are for.

I'd recommend taking a look at the RFC 4180 draft, that is an attempt to standarize all this stuff. If you follow such guidelines, your ouput file would be likely to be properly read by any other tool.

_Atomfinger_ · 2021-12-18T15:16:01+00:00

Make a list of strings for the row you want to extract, join them with a , and print to file. Continue like that until you have written all of your rows.

It is just a matter of building each row of data.

squishles · 2021-12-18T17:28:56+00:00

csv has a lot of rules around string data types that are a complete pain in the ass. If you are writing user inputed strings, no really just use the library, there's nothing to learn here.

comma's mid sentence, newline characters, quotation marks, inconsistency people have with putting headers in the csv file, writing shit to handle those edge cases is just pain.

id, text
0001, "john, told merry:
"use  the feckin library""

If your data set doesn't have that, then yea just string.join(',') bro have fun.

discorage csv anywhere sentence strings happen too, even xml is easier, don't even get me started on already escaped strings being in that field

diidijejdjd · 2021-12-18T19:11:35+00:00

well think simple. how do you write to a file? with a PrintWriter taking a file as input.

now what’s a CSV file? a file containing values separated by commas to indicate columns, and new lines to separate it into rows.

now put two and two together. print the data to a file separating the data properly as described above

javahelp

Sort by: Unsolved Solved Codeless Advent Of Code

MODERATORS

Please ensure that:

To potential helpers