Recent content by tbarthen

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]

Looks like there may be some minor syntax errors: awk: syntax error near line 12 awk: illegal statement near line 12 awk: syntax error near line 21 awk: illegal statement near line 21 awk: bailing out near line 24 I'd fix it myself, but I'm just a beginner with PERL. It looks like the error...

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...