Search results for query: *

Can't believe I didn't think of that myself [thumbsup] Thanks Dave!

I get the following error using your update statement: ORA-01427: single-row subquery returns more than one row I think its my fault for simplifying the scenario too much. Table t2 may actually have duplicates in the TYP column, and I believe this is what is causing the error. In fact, there...

Thanks for the valuable website. I'll read through it, and figure out what I can do. To answer your statement: "The question should be Is it worth trying to do? not Can it be done?" ....... Yes - it is worth trying to do, because the testing team I am supporting can not continue their...

Simplified scenario: Table t1 type_cd category_cd (need to populate this column) abc def ghi jkl mno pqr stu vwx Table t2 tbl_id type_cd cat_cd 001 abc COL 002 def STA 003 ghi JDG 004 jkl SAC 005 mno...

Using: Microsoft Biztalk Server 2004 Microsoft Visual Studio .NET 2003 Does anybody know how to do a keyword search (or search for a phrase) in an orchestration view? I know that you can do "find in files" (that binoculars icon on the Visual Studio toolbar), but that will only show you the...

mikevh, That is exactly what I was looking for! Thanks! [cheers] [rockband]

I see. Thanks for the tip. I'll try to get a different version of awk. Thanks again for the script. [thumbsup2]

...It looks like the error has something to do with this: write(file, array) I googled for examples of that syntax and found 2: write(file, array, 4*count); xfercount = write(file, array, rows * cols); Maybe the errors are obvious to you once you take a closer look. I don't know PERL well...

I have a directory of files - some of them with the naming convention *.input What I would like to do is run the following command-line global replace on all of these *.input files: For files *.input, replace the 15th to the last character of lines 2 and 3 with 'mystring' If its any easier...

Yeah, I wasn't sure if this was very suitable for a Perl forum, but I couldn't really think of a better place to ask. Maybe a Unix forum would be better. Anyways, you're probably right. I doubt there is a way to do this. Thanks for the reply.

I know that you can use Ctrl-% to match the brackets or parenthesis in a perl script from with the vi editor. I was wondering if there is also some trick to locate the definition or "origination" of a selected variable in a script. Does anyone know if this is possible? [hammer]

Beautiful, nice work, and so simple. Thanks for the quick response too

Hey, I was wondering if anyone can come up with a macro for the following problem: I have a spreadsheet with 2 textboxes on it. So a user can enter data within these textboxes as well as enter data in cells on the sheet. Some users have asked to make it possible to tab out of a textbox after...

Well, alright then. I guess I won't waste my time with that problem. Thanks for saving me the time and trouble.

I have an Excel worksheet which contains merged cells that users can paste various data into. I know that the user can press the F2 function key before pasting, or just click in the formula bar first - but the users don't always know that, and as a result, the following error happens: "Data on...

Hey, that's pretty cool. I never noticed that wildcard option. Thanks a lot for your help guys.

...you right, you're saying that I should bring up the replace dialog in Word (control-h), and in the "Find what" space, I should enter: (\*)(?{1,})(\*) and in the "Replace with" space, I should enter: |\2^p I did that, and it doesn't find anything to replace. Am I...

...of a string in a document, and then replace the remaining instances of that string with a different value. Specifically, I have a document that is * delimited. I would like to replace every other star with a pipe ( | ). Then I would like to follow that with a global replace of the...

Let me resolve this for anyone who cares. I think that would be just myself. Click on the Windows Start menu, and chose run. Type the following command and run it: "C:\Program Files\Microsoft Office\Office10\Excel.exe" /regserver Or if the directory path to your Excel.exe file is...

Hmmmm........I'm not sure how your answer applies to my procedure Skip, but anyways, I figured it out. I had to remove the word "Item" from the code. this line works: ActiveWorkbook.Names("initials").RefersTo = init Thanks for responding to my question though.