Thread: Working with CSV files

How to delete a word from the csv file

Unless you want to parse the csv file yourself, you would need to use a utility class like in the Apache project to read in the lines of the csv file, delete the word and write out the updated csv file.

It may be a little complicated for a beginner.
Which way do you want to do it?
Write your own code to parse a csv
Use the packages from the Apache project

import extensions.CSVFile;

CSVFile wordPrice = loadCSV("wordPrice");

class Word {
 String word;
 int price;
}

void play (Word info) {
 
  int RightPrice = info.price;
  int Price;
  println("What is the price of'" + info.word);
 
 
  do{
   counter = counter + 1;
   Price = readInt(); 
   if (Price<RightPrice){
    println("It's +");
   }
         else if (Price>RightPrice) {
    println("It's -");
   }
  }
  while(Price!=RightPrice);

Word randWord(){
  Word mp = new Word();
     int line = (int)(random() * rowCount(wordPrice)); 
     mp.word = getCell(wordPrice, line, 0);
     String price = getCell(wordPrice, line, 1);
      mp.price = stringToInt(price);
     return mp;
    }

boolean replay(boolean exit) {
 
		println("Do you wan to play again (Y : Yes, N : No) ?");
		char answer = readChar();
 
 
		if(answer == 'N') {
			exit = true;
		}
		if(answer == 'Y') {
			exit = false;
		}
		return exit;
	}

boolean exxite = false;
while(exxite == false) {
			Word randWord = randWord();
			play(randWord);
			exxite = replay(exxite);
		}

csv name: wordPrice
There are two columns, one with the words and the other with the prices

Did you have any questions or comments about the code that you posted?

I don't know how to do it

Can you write a detailed list of the steps that the program needs to take to solve the problem?
Do not try to write an java code yet.
When we have agreed on the steps the program needs to take, then pick the first step, write the code for it and test it.
When the test works, move to the next step and do the same.