I have a UTF-8 file that contains English and Spanish text. The Spanish text uses characters like a tilde. Additionally, the text contains copyright and trademark symbols.
I need to convert the file to ASCII format to use import into a new application. I tried converting the file in Linux like this but the resulting file is striped off all special characters:
iconv --from-code UTF-8 --to-code US-ASCII -c originalfile.txt > newfile.txt
I can also convert the file in the PHP application before generating (if easier).