Funny Urdu Script
Jacque Waiden
This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.
I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the "special" Spanish characters that aren't ASCII characters. It also seems to do this with the left and right quotes and long dashes that appear to be coming from the original user creating the Excel file in Mac.
Since CSV is just a text file I'm sure it can handle a UTF8 encoding, so I'm guessing it is an Excel limitation, but I'm looking for a way to get from Excel to CSV and keep the non-ASCII characters intact.
Save the Excel sheet as "Unicode Text (.txt)". The good news is that all the international characters are in UTF16 (note, not in UTF8). However, the new "*.txt" file is TAB delimited, not comma delimited, and therefore is not a true CSV.
If UTF-16 has been properly implemented with support for non-BMP code points, that you can convert a UTF-16 file to UTF-8 without losing information. I leave it to you to find your favourite method of doing so.
Fortunately, I have found that the lost character issue only happens (in my case) when saving from xlsx format to csv format. I tried saving the xlsx file to xls first, then to csv. It actually worked.
As funny as it may seem, the easiest way I found to save my 180MB spreadsheet into a UTF8 CSV file was to select the cells into Excel, copy them and to paste the content of the clipboard into SublimeText.
Assuming an Windows environment, save and work with the file as usual in Excel but then open up the saved Excel file in Gnome Gnumeric (free). Save Gnome Gnumeric's spreadsheet as CSV which - for me anyway - saves it as UTF-8 CSV.
Easy way to do it: download open office (here), load the spreadsheet and open the excel file (.xls or .xlsx). Then just save it as a text CSV file and a window opens asking to keep the current format or to save as a .ODF format. select "keep the current format" and in the new window select the option that works better for you, according with the language that your file is been written on. For Spanish language select Western Europe (Windows-1252/ WinLatin 1) and the file works just fine. If you select Unicode (UTF-8), it is not going to work with the spanish characters.
Came across the same problem and googled out this post. None of the above worked for me. At last I converted my Unicode .xls to .xml (choose Save as ... XML Spreadsheet 2003) and it produced the correct character. Then I wrote code to parse the xml and extracted content for my use.
You just have to provide the Excel file as first parameter followed by the sheets that you would like to export. If you do not provide the sheets, the script will export all worksheets that are present in the Excel file.
There are faster ways, like exporting as csv ( comma delimited ) and then, opening that csv with Notepad++ ( free ), then Encoding > Convert to UTF8. But only if you have to do this once per file. If you need to change and export fequently, then the best is LibreOffice or GDocs solution.
Here are twenty of the best comedy scripts that you can download and read to help make writing a comedy script that much easier. Study these funny scripts and learn how to amp up the funny in your own screenplay.
Selling comedy scripts in Hollywood is a tough business. But a sure-fire way to make it that much easier is to give us a protagonist who leaps off the page. Make him or her someone unique, memorable and most of all, funny.
A great way of putting a new twist on a genre is to combine it with another. This is exactly what the Coen brothers did when they created this Raymond Chandler-esque crime story and infused it with a strong dose of surreal dope-infused humor.
The script, by actors Emily V. Gordon and Kumail Nanjiani, is semi-autobiographical. The main storyline is based on their actual courtship before they got married, and many of the events actually happened in one form or another.
The movie that proved romantic comedies can still be huge worldwide hits was based on the best-selling novel by Kevin Kwan. His book was also inspired by events in his personal life and he began writing it after his father died as a way to cope with his grief.
This screenplay, like most Woody Allen comedy scripts, is a great one to study in order to understand how to implement a strong theme. The idea of a nostalgic screenwriter, Gil, in Paris with his fianc who finds himself being transported back to the 1920s every night, probably came to Allen off-the-cuff.
But imagine if the script he then wrote just had Gil getting into a meaningless adventure in 1920s Paris. Imagine the script had nothing to say about the nature of nostalgia and learning how to live in the present.
In fact, this is what persuaded writer/director, Brad Bird, to come on board. He was taken in, not only by the high concept of a rat who fears kitchens yet longs to work in one but also by the potential for so much physical comedy. A must-read for all budding comedy writers.
Mike White, writer of great comedy scripts such as The Good Girl and Year of the Dog, etc. is maybe best known for this 2003 movie, School of Rock. The version included here is from June 7, 2002 and has a completely different opening to the shooting draft.
The 2002 draft opens on a seven-year-old Dewey being reprimanded by his parents for slacking at school. We then see him transfixed by AC/DC on TV. Then at school, smashing a plastic guitar on the floor. This is all good stuff, but note how much more hard-hitting the opening is in the shooting draft.
Two middle-aged losers still living at home with their single parents are forced to become roommates when their parents marry. This is a great idea for a comedy script, but how did the writers come up with it?
This simple story about two high school seniors trying to impress some girls by throwing a mammoth house party could easily have wound up feeling empty. (Like so many other high school movies.) What places the Superbad script above the pack, however, is its heart.
Interestingly, Seth MacFarlane originally conceived of Ted as another animated TV show in the vein of Family Guy, The Cleveland Show and American Dad. However, he changed his mind and brought on fellow Family Guy writers, Alec Sulkin and Wellesley Wild, to create this R-rated comedy about a slacker who lives with his talking teddy bear.
64591212e2