* boolean If the next row is a valid row. * This method checks if the next row is a valid row. * boolean Returns true on EOF reached, false otherwise. * This method checks if the end of file is reached. * This method returns the current row number. $this -> currentElement = fgetcsv ( $this -> filePointer, self :: ROW_SIZE, $this -> delimiter ) * array The current csv row as a 2 dimensional array * This method returns the current csv row as a 2 dimensional array Note: If back slashes are used to escape quotes they can easily be removed afterwards. From my own benchmarks fgetcsv strikes a very good compromise between memory consumption and speed. (It does need help for macintosh line breaks though, as mentioned in the help files.) So fgetcsv if actually very complete and can deal with every possible situation. (So previous comments stating the opposite are wrong, unless they are using a different PHP version. Line breaks within fields are dealt with correctly if they are in quoted fields. leading and trailing spaces (\s or \t) are never removed, regardless of whether they are in quoted fields or not. If it is not inside a quoted field it will stay). If a single double quote is inside a quoted field it will be removed. \" will give \" whether it is in a quoted field or not (same for \\), and Two double quotes "" will give a single " once parsed, if they are inside a quoted field (otherwise neither of them will be removed). (i.e.Let's use the double quote (") as the quoting character: The quoting character is escaped by itself and not the back slash. The fgetcsv function seems to follow the MS excel conventions, which means: Output the data, looping through the number of lines of data and also looping through the number of cells in each line, as this is a dynamic number the header length has to be reread.
loop through the headers outputting them into their own cells It works on the assumtion that the first line is the header row. useful if you back up your cell phone address book and it outputs CSV.
#Bbedit csv line up code
I don't perclaim my code is 100% perfect or correct, but it works. A simple script to output the contents of a CSV file as a nice table - should be totally dynamic and can use any seperator - it does not have to be a comma (,).
0 kommentar(er)
