I extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel?
E.g.
Date----------Formula---------Result-----What I want!
01/03/2010---Month(Date)--------3----------MAR
Thanks
Mike
I'm certainly trying to achieve something weird here, but I want to fake the date locally for a shell session on GNU/Linux.
I need to black-box test how a program behaves at different dates, and modifying the system-wide date can have unwanted side effects (cron jobs, messed up logs, etc).
Any ideas ?
How can i generate a list of files in a directory [e.g.: "/mnt/hdd/PUB/"] ordered by the files modification time? [in descending order, the oldest modified file is at the lists end]
ls -A -lRt would be great: https://pastebin.com/raw.php?i=AzuSVmrJ
but if a file is changed in a directory it lists the full directory...so the pastebined link isn't good [i don't want a list ordered by "directories", i need a "per file" ordered list]
os: openwrt..[no perl - not enough space for it :( + no "stat", or "file" command]
Thank you!
Hi,
What possible way that I can optimize the boot-time of a Linux OS? Should I modify some scripts or init scripts? If yes, what are the scripts? Can I modify the kernel source?
Many thanks
How can I generate a list of files in a directory [for example, "/mnt/hdd/PUB/"] ordered by the files modification time? [in descending order, the oldest modified file is at the lists end]
ls -A -lRt would be great: https://pastebin.com/raw.php?i=AzuSVmrJ
But if a file is changed in a directory, it lists the full directory, so the pastebined link isn't good [I don't want a list ordered by "directories", I need a "per file" ordered list]
OS: OpenWrt [no Perl - not enough space for it :( + no "stat", or "file" command].
Why does hardware get slower with time? I have been a PC owner since 1990 and every computer I have had in my life became really, really slow after 3-4 years (even with a full system-reinstall). It is the case with Windows PCs. It is also the case with Apple Hardware. Why is this happening? Can this be avoided?
I need a program (with an easy learning curve) that lets me slow down mp3 (at the very least this format) music and audiobook files. The software needs to be able to slow down the audio at the chosen speeds without altering the pitch and accuracy of the words being pronounced. Perhaps like the language software "Byki Deluxe's" "SlowSound" feature? I'm learning a foreign language (German) and I find the speeds at which the books are being read too fast. I need to hear the pronunciation of each word much more clearly to learn how to pronounce the words myself.
Is there such a product out there? Now, I know you can slow down stuff in VLC but it sounds really artificial. I need something that slows down audio files without altering the accuracy of the words being pronounced.
It doesn't have to be freeware; ease of use and quality is more important to me.
Win 7 64-bit. IE 8.
Edit: Are there any software-for-pay like Audacity? Only the beta works in Win 7. Also, I'd prefer to be able to slow down a file live and not have to create a new file to use the feature.
I just bought Asus Refurnished Netbook. For some reason it is taking an eternity for the first time charge. I have already plugged in for 3 hours and still it does not even open and shows LOW battery. Any ideas?
I just went to my first hackathon (London GreenHackathon) and I want to go to lots more. Specifically, hackathons that have a theme of helping people or making the world a better place in some way. I know about Random Hacks of Kindness and a couple of others but is there some central aggregator that will help me find out about hackathons?
Also, if anyone else can suggest specific hackathon initiatives I should check out that would be handy too.
I'm in London but obviously for other people reading this question other locations will be of interest.
From a Windows XP command line, how do I get the time I logged into and/or out of the current machine? I'm looking for something like the UNIX last command which lists active and previous login sessions.
Thanks,
John
In the SuSE /etc/crontab the entry to run the cron.{hourly,daily,monthly,weekly} scripts is coded as:
-*/15 * * * * root test -x /usr/lib/cron/run-crons && /usr/lib/cron/run-crons /dev/null 2&1
Notice that the very first character of the specification is a dash character (-), and this is NOT a typo.
Can somebody explain what the time spec '-*/15' means?
BTW, the stuff seems to be running fine.
Thanks
I have time values entered in Excel as a custom number h:mm. I would like to convert these to a format (still displayed as h:mm) which will allow me to perform calculations using the data. Any ideas?
Is there a utility for windows 7 which will give me the time remaining until my laptop battery is fully charged. GNOME power manager has this functionality, So i was wondering if there is a counterpart for windows 7
For a relatively large network (thousands of hosts) - what are the arguments for and against running a locally managed (pool of) NTP server(s) (perhaps periodically set via some public NTP server) and having all other hosts on the network use that (pool of) NTP server(s) versus having all hosts simply use public NTP servers directly, say via ntp.pool.org?
Aside from the pros and cons, What is typical best practice today?
Given I am running a real estate rentals listing website, what would be the correct microdata or microformats for the listing pages? There is the usual data: address, photos, price, start date, possible end date, person who is renting it out, list of amenities, description etc.
Are there also microformats/microdata that can be used in the listing summary page (e.g., page that displays all listings in a particular city)?
<b>Free Software Magazine:</b> "When we think of free operating systems we tend to think overwhelmingly of the big hitters (all GNU/Linux) like Debian, Ubuntu, Fedora and Mandriva and then of those niche distros that have been designed for low end systems or for specialist purposes like security and forensics. But Oranges are not the only fruit"
Imagine, hypothetically of course, that you are being commissioned to develop a full-fledged real estate website that includes:
1) a search engine with ajax/json autofill,
2) google maps and geolocation integration, google streetview,
3) user registration, login and account management
4) administrative panels to control data input
5) search results page
6) user statistics
7) property inquiry to allow internal messaging between users
How much would you charge? Suppose you are developing the most advanced and specific system in PhP/MySQL, and your total development time is roughly 1500 hours? Any suggestions?
Has anyone seen some copy/paste software with the feature to paste one word at a time?
I am filming a demonstrative video and want it to appear I am typing a long-winded canned product description.
I'm using Camtasia recording studio on Windows XP to record data input in a website.
Back in the day, TCP connections over dialup/ISDN/slow broadband resulted in choppy, laggy games because a single dropped packet resulted in a resync. That meant a lot of game developers had to implement their own reliability layer on top of UDP, or they used UDP for messages that could be dropped or received out of order, and used a parallel TCP connection for information that must be reliable.
Given the average user has faster network connections now, can a realtime game such as an FPS give good performance over a TCP connection?
After a quick search I found that through a command prompt I can convert a drive from FAT32 to NTFS without losing data(see here). What I want to ask here is, how safe is this method on a 1.5 TB drive with 500 GB of data?
What are the chances of this freezing up(or is there really nothin to worry about) and what is the probable time, a couple of minutes or a whole hour?
Sorry if this seems like a stupid question, just want to play on the safe side here ...
Possible Duplicate:
How do I replace the MeMenu username with my actual name?
My user name takes approximately as long as would 6 icons. I don't need to see my username, I am the only user of my computer. How can I remove it?
I use Ubuntu 10.10.
UPDATE: The answer found:
gconftool -s /system/indicator/me/display --type int 0
UPDATE: Unfortunately the solution doesn't work any more. Now it totally removes the instant messaging menu (including the icon) instead of just removing a name.
I'm interested in locking down my PC so that only a few programs can be used.
For example, when I'm writing a paper I only want to be able to use Word. No Firefox or DVD player because I will be distracted.
I want to have various modes (one for writing a paper, another for doing taxes) that will prevent me from using any program except for the ones I need to perform a task.
Is there a program that will do that? Can be free or commercial.
I have a problem with the calendar gadget in Vista. The starting day is Sunday, but I would like to change it to Monday.
I have checked some forums which points me in the direction that:
Change the Regional Settings in ControlPanel to your local region
Change the register key HKEY_CURRENT_USER/Control Panel/International/iFirstDayOfWeek to 0
Both of these are already correct, so it didn't help me.. Does anyone else have a suggestions?
Each time I make some changes to a file and save, I'd like a command to run. I can set up a Ruby script that could monitor the file and run the command as I'd like, but it occurs to me that there should be some simple Unix way to do this. Is there?