Recent content by Imagineer

I am using excel '97. (Yes, I know it is old but for various reasons, we can't upgrade this specific machine). Anyway, what I basically need is an "IsFunction" function or the functional equivalent. Where I pass it a reference and it will tell me if that reference contains a...

Import them as a text instead of a number. When you do the text to columns command, you can select the format for each column. Using the wizard, in step three select the column, then click the "text" radio button in Column data format. Imagineer

Hello, I'm unix hand that is a novice at WORD macros/programming so I'm having problems with this code. We have some text files that are being combined and then brought into word for document type formatting, etc. In the original text file, the authors put [LANDSCAPE:ON] and...

Found my own answer. I was searching for "command line" at support.microsoft.com. Silly me. I need to search for "command PROMPT". Imagineer

What is the registry key for the command line here option. I know that it is part of the Resource kit but that disk has been misplaced in our IT dept. Imagineer

The real question is "what are your delimiters, i.e, what character immediately precedes 'J' and succeeds 'n'?". I suspect that the space didn't work because the character was in fact a tab. If you have a POSIX version of grep then the expression would be...

Permanence is a relative thing. What I meant was that I needed them to last beyond the current session of awk. Awk allows you to read the environment variables using the ENVIRON array. The values in the ENVIRON array can be changed but they do not return these values back to the OS. All...

I'm trying to set some environment variables in a DOS (actually WinNT 4.0 cmd) shell. I know that changing the value in the ENVIRON variable does not pass the value back to the shell. I've tried using the system() command thusly, sVar = "EnvTest" sValue = "oldhat" if...

Subject says it. TIA, Imagineer

Nevermind. I found the note that the circumflex is the negation operator if it is the first character in []. Imagineer

hmm... why the ^? Isn't that the beginning-of-line metachar? Do you mean the negation operator "!"? Thanks, Imagineer

But I need the space to define end-of-word. Otherwise the expression would match to end-of-line. Since I will be holding the word, I don't want the rest of the line. Imagineer

Oops, there should be a space after the *. The regex tried is "IN.* ". Basically, I'm trying to find words beginning with "IN". Thanks again, Imagineer

Hmm.. for some reason this regex is not working. I am using the cygwin version of gawk. It only finds lines 1, 2, 13, 18, 31, 38 of the attached file. It appears that the "*" is not working. I really wanted it to match lines 21, 25, 31, 50. I even tried "IN..", still no...

mns, IIRC, ' specifies left justified text. " specifies right justified text and ^ specifies centered text. Imagineer