Format to read in CSV files

[Stellaferox]

Thanks Erel, I will do so.
Marc

[LineCutter]

Originally Posted by Stellaferox

I want to store a table containing numbers. The program computes the rank of a hand in poker with 7 cards, taken the best 5 out of it (Texas Holdem). Because there are 133784560 combinations with 7 cards out of 52, it takes too long to compute the hands, especially because I want to run simulations with dealing a lot of hands (Monte Carlo simulation) and compute the probability of winning with that certain hand against other random AI-hands.

You're going to have fun sorting out which hands are valid after you drew the first cards & the subsequent interactions that get you to 7 cards drawn per hand...

[Stellaferox]

Yeah I know. I worked out to check all 21 combinations of a 5-hand from 7 cards. That works faster then evaluating a 7-hand card I think.

[LineCutter]

I might have the wrong end of the stick - are you simply calculating the probable outcomes for a hand played all the way through, or are you including the role of the evolving shared cards in determining whether you play to the end?

[Stellaferox]

The first part of the program is to caculate the outplayed hand (7 cards). With that I can simulate dealing let's say 200000 hands and calcuate probabilities and distribution. Then for the second part I want to calculate probabilities to reach a certain hand with the ongoing play after dealing the several rounds.
The idea is whether I can create a table with pointers after each card to a next table with remaining possibilities. I haven't got it quite clear yet, but the first idea is to build the "mothertable" of all 133784560 combinations.
Marc

[Stellaferox]

But can I get back to the original question? What is the general format/ routine to read in CSV files. There are a number of CSV files on the net that I can use to train my program. After that I can write my own table in BinaryFile.
thnx
Marc

[agraham]

Originally Posted by Stellaferox

What is the general format/ routine to read in CSV files

Open one with Wordpad or Notepad. They are just normal text files.

If FileExist ("text.csv") = true Then
  FileOpen (c1,"text.csv",cRead ,, cASCII)
  r = FileRead (c1)
  Do Until r = EOF
    fields() = StrSplit(r,",")
    Msgbox(fields(0) & " - " & fields (1)) ' do whatever with the fields
   r = FileRead (c1)
  Loop
FileClose (c1)

[Erel]

If you want to parse CSV files you should use Table.LoadCSV.

[s_ostap]

I have a problem:

Table1.LoadCSV("Csv_file.csv",";",False,True)

File of "Csv_file.csv" contains information on Russian language. But the Russian letters are not represented in table cells.

[Bakhtiyor]

Open your csv in Notepad and save it in UTF-8. Russian letters should appear.