my profile | my password | search | faq & rules | forum home

» Film-Tech Forum ARCHIVE   » Community   » Film-Yak   » How to replace "The Movie Title" with "Movie Title, The" in Excel (Page 2)

This topic comprises 2 pages: 1  2

Author Topic: How to replace "The Movie Title" with "Movie Title, The" in Excel Frank Angel Film God Posts: 5305 From: Brooklyn NY USA Registered: Dec 1999 posted 09-01-2011 09:53 PM                        We'll have to disagree. All I know was that I did fine with WP and ever nearly had the frustrations that I had later when we went to WinWord. I started with the monospace DOS version of WP, but only for a short while -- then we quickly moved to WP's WYSIWYG DOS version where what you saw was what actually came out of the printer. We did posters, newsletters, brochures with ease, pictures, a great variety of mixed fonts, multiple columns for newsletters and great mail-merge work. Our current logo was created in WP and we still use it today. Maybe the Mac version wasn't as sweet, but yes, I call it very intuitive. The key cheats that you seem to dislike were great, right there in front of your eyeballs and within no time at all you had them all 12 F keys X4 memorized. Then along came Word and all those commands were NOT in front of your eyeballs, they were BURRIED quite illogically in menus after menus. Oh sure, after a decade of working with Word, it's no problem, but all I can tell you is that I found WP much easier at the very start that I did Word. Maybe this is because our first computers were running CP/M, so coming to a much more sophistocated WP in DOS seemed like an intuitive miracle. Try dealing with wordprocessing in the CP/M OS and then switch to WP; it's all relative. Actually I take that back; our first computers were a small network (only 8 workstations) -- an ALTOS system running on an early Linux. Just BREATH on that thing and all 8 stations would freeze. The server was so sensitive that if you accidently bumped into the table it was sitting on, the hard drive would crash...I mean, ruined. You gave that thing wide berth and walked quietly. When we had to move it, they walked with it as if they were carrying nitroglycerin.  |  IP: Logged Mark J. Marshall Film God Posts: 3188 From: New Castle, DE, USA Registered: Aug 2002 posted 09-01-2011 09:54 PM                    No problem, Mike! That was an easy one! When I first saw Word Perfect it was the old solid blue screen DOS based version. 5.0? I never really quite got the hang of it. I wish I could get fluent with vi. I find myself needing to use it on our servers every once in a while. Wish I knew more about how to do the basics with it.  |  IP: Logged Frank Cox Film God Posts: 2234 From: Melville Saskatchewan Canada Registered: Apr 2011 posted 09-02-2011 12:12 AM                        There are numerous vi tutorials (just run "vi tutorial" through google) and the best book I'm aware of is Learning the Vi Editor, Sixth Edition  |  IP: Logged Mike Blakesley Film God Posts: 12767 From: Forsyth, Montana Registered: Jun 99 posted 09-02-2011 12:51 AM                        quote: Mark J. Marshall When I first saw Word Perfect it was the old solid blue screen DOS based version. 5.0? I think that's what I had. I think I might have "juxtaposed" WP 5.0 with Windows 3.1 which was the first Windows I had. I remember being quite confused when I booted up WP for the first time and there was nothing but this blank blue screen with a cursor on it. But Frank's right about the manual, it was huge and a nice thing to have. I have discovered many a feature flipping thru a manual. I'm a big reader, but a lot of people don't want to take the time so... I can see why printed manuals have gone away. Doesn't make it a good development though!  |  IP: Logged Ian Freer Expert Film Handler Posts: 135 From: Wellington, New Zealand Registered: Oct 2003 posted 09-02-2011 03:20 AM                     Frank, if you are keen to migrate from File Express, Microsft Access is possibly what you want to look at. It is a database program that stores records (with record numbers) in a way similar to File Express. I have not used Access for a long time, but when I did (although I did not find it was the most user friendly), if you dig into it, it will definitely do everything (and probably a whole lot more) that File Express does... There may be a pre-built template for both the Database/fields and the Reports that will work for you if you're lucky... There are probably Open Office / open source equivilents too...  |  IP: Logged Joshua Waaland Jedi Master Film Handler Posts: 800 From: Cleveland, Ohio Registered: Dec 1999 posted 09-02-2011 08:41 AM                     I had to take a required course in college back in 1998 that was called "computer science 101". It was basically a course on using Excel and it's built in component visual basic. the Excel part was fine but I really floundered when it came to visual basic. the first time through the course I did not really try very hard and so I had to take it again. Even the second time through I had a hard time. I would go to the computer lab and sit there for hours working on a program and the freshman would come in and sit down and bang out the same homework assignment in fifteen minutes. Most of them had this stuff in high school but I had graduated high school four years before that and was a non-traditional student. When I was in junior high school we only had computers with text and no graphics. I think we were using Apple IIE computers at that time. By the time I got to high school in the early nineties, I was taking vocational drafting and we still did all of our drawings manually on the drawing board. We had two new computers in the corner of the room that were 486's and they had Autocad release 12 on them. Our teacher did not know how to use Autcoad and it was not part of the curriculum yet. We were allowed to play around on them when we had all of our work done so whatever we learned was on our own. Kids in today's world can write a phone app or bang out a program like nothing. Sometimes I think it is like a second language to them. I grew up right on the cusp of computers taking over and I didn't get to learn like these kids do now. They have a definite advantage over me in that respect.  |  IP: Logged Mark J. Marshall Film God Posts: 3188 From: New Castle, DE, USA Registered: Aug 2002 posted 09-02-2011 09:34 AM                    We had Apple IIEs and II Pluses or whatever they all were when I was in Middle school, and IIGSs in High School. Visual Basic is one of the most illogically structured languages I have ever seen. Maybe it's just me, but I've written code in C, C++, TI Basic, TI Extended Basic, Apple Basic, Amiga Basic, PHP, Java, Javascript, and who knows how many scripting languages, and I've read books on Pascal, Assembly language, and MySQL stored procedures. Visual Basic doesn't make sense to me.  |  IP: Logged Aaron Mehocic Jedi Master Film Handler Posts: 804 From: New Castle, PA, USA Registered: Jun 99 posted 09-03-2011 08:02 PM                     Joshua, I had identical experiences as you did back in the early days of Auto CAD as well. I actually preferred to do my drawings by hand, however, since the CAD system had several bugs that nobody in those days really understood. Now that I'm back in trade school some 20 years later, my instructors always give me high marks on the neatness of my drawings. The kids right out of high school have no idea how to draft unless it is through CAD. That's pathetic in my opinion.  |  IP: Logged Scott Jentsch Phenomenal Film Handler Posts: 1061 From: New Berlin, WI, USA Registered: Apr 2003 posted 09-09-2011 11:13 AM                        I was a WordPerfect junkie from the 4.2 days, when all you had was a text-based interface with the function keys to do just about every command you would need. Others are correct in their statements that once you learned these keystrokes, you could get so much done in so much less time than having to hunt through menus. For those looking for true efficiency, keyboard shortcuts are always going to be faster than point and click menu choices. While WordPerfect 5 tried to introduce mouse control into the text-based interface, it wasn't as easy as just using the keyboard shortcuts. It took WordPerfect a few versions to get the hang of a GUI interface, but they did it, and once they did, they had a program that was very functional and negated the need for many to have expensive and difficult to use desktop publishing programs, like Ventura and Pagemaker. Really advanced page layout still needed those programs, but WordPerfect was very good at it. The most powerful thing about WordPerfect? Reveal Codes. With Reveal Codes turned on, you could figure anything out. I had to give up on WordPerfect when I moved to Windows 7 64-bit and couldn't get it to install properly. As I wasn't doing much document writing any longer, and rather than purchase an updated version of the program, I decided to make do with Word. After several years, I still swear while using Word. It does inexplicable things, and it can't do labels decently to save its life. Publisher is page layout for dummies, but it actually does labels better than Word can. I use both programs as little as humanly possible because they often waste more time than they're worth. If I ever have to do more work in a Word Processor, I'll probably just purchase the latest copy of WordPerfect that will hopefully work on my system. I'll be money, time, and frustration ahead. All this is said, of course, with the realization that people who grew up with Word feel the same way about WordPerfect that I do about Word. I guess it's all about what you cut your teeth with...  |  IP: Logged Kenneth Wuepper Phenomenal Film Handler Posts: 1026 From: Saginaw, MI, USA Registered: Feb 2002 posted 09-09-2011 05:44 PM                     Scott said "I guess it's all about what you cut your teeth with.." That is exactly why Apple computers are in the public schools. KEN  |  IP: Logged

All times are Central (GMT -6:00)

This topic comprises 2 pages: 1  2

Printer-friendly view of this topic

Hop To: Select a Forum: Category: Operations -------------------- Digital Cinema Forum Film Handlers' Forum Large Format Forum Ground Level Feature Info, Trailer Attachments & REAL Credit Offsets Category: Community -------------------- Film-Yak Film Handlers' Movie Reviews The Afterlife Bob Maar's Joke-A-Thon Category: Classified -------------------- Equipment and Supplies Wanted/For Sale Help Wanted/Seeking Employment Category: System -------------------- Software Beta Testing Forum

The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion and agrees to release the authors from any and all liability.