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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tbarthen

    Set t1.col2 = t2.col3 where t1.col1 = t2.col2

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

    Set t1.col2 = t2.col3 where t1.col1 = t2.col2

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

    Set t1.col2 = t2.col3 where t1.col1 = t2.col2

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

    Set t1.col2 = t2.col3 where t1.col1 = t2.col2

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

    Searching keywords/phrases in an orchestration view

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

    Global replace nth character of nth line of all files

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

    Global replace nth character of nth line of all files

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

    Global replace nth character of nth line of all files

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

    Global replace nth character of nth line of all files

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

    Finding a variable definition in perl

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

    Finding a variable definition in perl

    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]
  12. tbarthen

    Can't tab from controls to cells on a sheet & vice versa

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

    Can't tab from controls to cells on a sheet & vice versa

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

    Trapping error when pasting to merged cells

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

    Trapping error when pasting to merged cells

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

    Word macro to replace every other instance of a string

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

    Word macro to replace every other instance of a string

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

    Word macro to replace every other instance of a string

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

    Excel files keep reopening since Office XP upgrade

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

    Assigning a variable to RefersTo in Excel

    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.

Part and Inventory Search

Back
Top