replace a value in csv file using java

Asked Jan 23 '18 at 06:06

Active Jan 23 '18 at 06:19

Viewed 1,049 times

I want to update a particular column in csv if the condition is met. For example

 engineer,i
 doctor,i

is the csv file,once the row is visited i want to change the "i" value to "v"

for(String line1 :lines)
{
    String[] array1 = line1.split(",");
    if(array1[1]=="v")
    {
        continue;
    }
    else
    {
        double distance = compute(array[0], array1[0]);
        if(distance>0.8)
        {
            lines1.add(line1);
            array1[1]="v"; //why this line doesnot update that column
        }
    }
}

so how to update or replace a value in csv file???

edited Jan 23 '18 at 06:19

Waleed Iqbal

1,308
19
35

asked Jan 23 '18 at 06:06

SHALINI

1

[FYI](https://stackoverflow.com/questions/513832/how-do-i-compare-strings-in-java) – shmosel Jan 23 '18 at 06:07
`array1[1]="v"; //why this line doesnot update that column` The array is not linked to the CSV. You'll have to write it back to the file. – shmosel Jan 23 '18 at 06:08
1

Uh... `1` make your code easy to read by removing the excessive indentation, and `2` are you asking us to read all the comments in the code to find out what's the question? – user202729 Jan 23 '18 at 06:09
how to write it back to that file...i searched a lot but didnt get any answer @shmosel – SHALINI Jan 23 '18 at 06:24
Strings are compared using `equals` function not `==` operator – Ali Faris Jan 23 '18 at 06:26
we can compare it like that ,betweet that is not my problem,i just want to update the file @ali – SHALINI Jan 23 '18 at 06:30
check if `distance>0.8` passes and add this line at the end of your loop `System.out.println(Arrays.toString(array1));` – Ali Faris Jan 23 '18 at 06:40
Parsing CSV is trickier than it looks. Use an existing, reliable CSV library like OpenCSV or Apache Commons CSV. – Jim Garrison Jan 23 '18 at 07:32
will netbeans 8 support openCSV @Jim – SHALINI Jan 24 '18 at 08:35

replace a value in csv file using java

0 Answers0