Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Imagineer
-
Excel "IsFunction" function needed
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...- Imagineer
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Excel - have a csv file retain leading zero
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- Imagineer
- Post #4
- Forum: Microsoft: Office
-
Word Macro needed: How to search then change page orientation
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...- Imagineer
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
Registry Location for Cmdhere
Found my own answer. I was searching for "command line" at support.microsoft.com. Silly me. I need to search for "command PROMPT". Imagineer- Imagineer
- Post #2
- Forum: Microsoft: Windows
-
Registry Location for Cmdhere
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- Imagineer
- Thread
- Replies: 1
- Forum: Microsoft: Windows
-
grep function to find exact word
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... -
Permanently setting Environment Variables in DOS
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... -
Permanently setting Environment Variables in DOS
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... -
How do I access the Pattern and Hold Spaces in AWK?
Subject says it. TIA, Imagineer -
Regex not working - "IN.*"
Nevermind. I found the note that the circumflex is the negation operator if it is the first character in []. Imagineer -
Regex not working - "IN.*"
hmm... why the ^? Isn't that the beginning-of-line metachar? Do you mean the negation operator "!"? Thanks, Imagineer -
Regex not working - "IN.*"
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 -
Regex not working - "IN.*"
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 -
Regex not working - "IN.*"
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... -
formatting in Excel
mns, IIRC, ' specifies left justified text. " specifies right justified text and ^ specifies centered text. Imagineer- Imagineer
- Post #5
- Forum: Microsoft: Office
