1) try this:
PHP Code:
$text = str_replace("'s", '', $text);
2) try this:
PHP Code:
$fd = fopen ("file.txt", "r");
// loop until EOF
while (!feof ($fd)) {
// read one line, up to 4KB
$buffer = fgets($fd, 4096);
// explode to get each field from line
$data = explode(";", $buffer);
// do some stuff to enter fields into DB
}
fclose ($fd);
PHP DOCS:
fgets(),
fopen(),
feof(),
str_replace