solved... I used another reference cell...
=TEXT(J9,"DD MMMM YYYY")

Which returns (for today) "26 January 2009".
I can then reference this cell elsewhere.

I am trying to keep formatting between cell references.

For instance, I have a date in once cell (J9) and would like to add this date to a text field so e.g.:

="This will take effect on " & J9...

I have this all figured out now.

Okay, I came up the following code which finds the cell address of the lookup (z) data.


Sub lookup()
Dim lookup
lookup = Range("lookup").Value
For each c in Range("lookup_range").Cells
If...

Unfortunately, I don't think this question is solved with a simple vlookup, or etc.

I have a spreadsheet that has several tables of data with the following format on one sheet:

gxxxx
gxxxx...

no - a job is still a single process. Jobs in fact are controlled by their Process ID.

eggi has it right - basically the only "difference" is that you can manage a job through the job manager...

I second that recommendation.

What have you tried so far?

Your phone numbers and addresses should have foreign keys to the contact table - not to the person table. e.g. Swap out p_id for c_id. THis is what he means by
"- Events, addresses and phones...

SQL Server creates primary keys (by default) as clustered - which means it gets sorted.

Create a NONCLUSTERED primary key and you should be all set.

I didn't realize you could call vi in a script like that and execute sed from there - I always sed the file and output to a temp file, and then read back in to the original... this is much cleaner.

A job is a process running in the background.

E.g.

./myscript.sh &
[1] myscript.sh 96243

A job relates to a command run from a terminal. It is attached to a terminal session. A command...

It seems so obvious looking at the function name.

Thanks for your help!

I would like to create a variable in my trigger - @DBNAME.
When the trigger executes, this value should be set to the name of the database it was executed in.

E.g. for the master database the...

Mike,

Definitely some genius code there.... the one thing you missed is that it needs to skip a column....

I was hoping you could just increment i by 2 - but that doesn't seem to work... I...

You have already been told - just use the mail command to do what you want to do, nested in the logic you want it done for.

For instance, the following will check to see if a file exists every 3...

Another suggestion - since it looks like you are comparing military time, it will be easier to make the comparison if you drop the ":".

You can do this with sed or tr or even cut very easily....

Hey - alternatively you can do this natively with the at command:


at now +3 days <enter>
/path/to/script <enter>
Ctrl-D


The at command actually waits for a Ctrl-D (EOF) for termination. ...

Your first problem is that you need to define the function above where you call it from - so you should have a functions section at the top of your script, which is where my code should be. I'm...

In my opinion, the easiest way to do this is simply:


net start messenger || echo Messenger service is currently disabled on your computer. Press F1 for instructions to enable this service.

...

Have you tried removing the semi-colon after the first line and tried running it that way?

In my experience, I only put a semi-colon there if the do will be put on the same line. I think that is...

I want to go to school where you people all go. My college classes were pretty limited.

I have never written pseudocode before - but I was under the assumption that you did not need to define variables - you just basically went through and wrote out (in a human readable format that...

^ Nice and simple, just the way I like it... though I'm more interested in the sed example.

with my above function:


while [ "$*" != "" ]
do
working_arg=`test_upper $1`
if [ "x${working_arg}x" != "xx" ]; then
echo "$working_arg is all lowercase."
fi
shift

Which part are you having trouble with?

I would have to know a little bit more about the naming scheme of your zip files and etc.

Try this:

function test_upper {
test=`echo $1 | grep [A-Z]`

if [ "$?" = "0" ]; then
#Uppercase letters found.
#translate to lower case:
echo $test | tr '[A-Z]' '[a-z]
else

The text is available, it was just a bit hard to read because you hadn't enclosed it in code tags.

It doesn't look like an overly complicated script - though I wonder if you have racadm installed?...

Niether of those solutions worked for me exactly as specified, however the following command worked fine:

$ for file in `tar tvf /u8/sp_archive/2005.tar | grep 1274 | awk '{print $9}'`
> do
>...

The best thing to do would be to find someone who is fluent in both vbs and shell scripting in order to have them convert the script for you. This may cost some money, especially depending on the...

Hey,

I'm trying to unpack certain files from a tar archive - I don't want to unpack all of the 1.2GB file, just a particular bunch of it.

I tried an obvious command:

tar xvf...

It actually probably should be in most secure environments...

Try this one:

telnet $mailserver <<END
user $USER $PWORD
/path/to/HELO
exit
END

The above from Salem's post needs to be done to fix your issue.. but you may also want to fix your if statement.


if [ "$result" = "$next" ]


The data in these variables are strings and...

I can only think of using a log file of sorts. At the beginning of your first script have it output a '0' (false) to the log file. At the end of the script, upon successful execution, have it...

Ancient Dragon is correct, there is no way of manipulating threads using batch - or in other words, there is no command redirection available under command.com which allows you to send command output...

That is definitely more advanced than I have worked with in the past.

It sounds like Canon has given you the command set available for their proprietary driver for this device. I think what you...

Try this:


g++ "C:\HellowWorld.cpp" 2> "C:\output.log"


You could probably also do:


g++ "C:\HellowWorld.cpp" 1>2> "C:\output.log"

Well, you will not make it very far in UNIX System administration without knowing Shell scripting. You will also do well with UNIX admin with C/C++ under your belt - or perhaps some python or maybe...

If this is PCL compatible, I can certainly help with that.

If its PostScript help you need, then I probably can't be of much assistance.

Can you identify the model of the printer, and whether...

You are only returning (echoing) the last iteration of badcommand. Your while/for/if loop above assigns the current argument that it is processing to the badcommand variable. You let that loop run...