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 Chriss Miller 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: *

  • Users: dunk2
  • Order by date
  1. dunk2

    Move non-formula cells in a range up one cell

    Hi, I want to move a range (D34:L44) of cells up by three rows if a) they do not contain a formula b) if they are non-zeros numeric I need to repeat this for all worksheets (about 30) that start with the letter 'Z' or 'P' I would like to be able to execute this by macro, saving a lot of manual...
  2. dunk2

    usleep performance under load

    Hi, sorry about the delay in reply. I checked out a few different methods of controlling processes Vs preformance. I ended up using the system function call running in parallel on two remote boxes. The boxes were comandeered for this purpose only, and produced my required output of 140...
  3. dunk2

    usleep performance under load

    Thanks, I'll try running the scripts in parallel on a faster platform next week, and I'll keep you updated on improvement stats.
  4. dunk2

    usleep performance under load

    That makes sense. I may have another 'faster' platform availble next week, which would decrease IO time. Thanks
  5. dunk2

    usleep performance under load

    Hi Paul, I should have mentioned that did edit out the usleep and it maxed out at 20 per second. I'm monitoring the cpu (using 'top') and the kernel cpu% increases from 5% to 20% when running inputs from 10 per sec to max. There still is idle cpu% available though, about 20%. The binary I'm...
  6. dunk2

    usleep performance under load

    Hi, I'm using perl to control a sleep on a Solaris 8 platform. It is part of a load test sript. It basically executes a command line ($smsPath/sstsms -m $null -f $subId -i $psp_3:5014 5555) and then usleeps for a configurable microsecond, before looping again. This works well up to a usleep...
    • dunk2
    • Thread
    • Replies: 10
    • Forum: Perl
  7. dunk2

    convert a file_name from upper case to lower case

    Thanks guys, that worked a treat.
  8. dunk2

    convert a file_name from upper case to lower case

    Hi, I want to convert a couple of hundred file names in a folder from upper case to lower case. e.g. /tmp/UPPERCASE1.DATA to /tmp/uppercase2.data I'm using a Solaris 2.8 platform. Is there a neat awk script that can do this?
    • dunk2
    • Thread
    • Replies: 3
    • Forum: AWK
  9. dunk2

    Count the occurrence of different field values.

    Many thanks CaKiwi, it's a neat solution, dunk2
  10. dunk2

    Count the occurrence of different field values.

    Hi CaKiwi, Unfortunately, your solution but it results in the same 'fragmented' output....e.g. 4 169254214268., 0000001.00, 20051129 3 024731477144., 0000002.00, 20050807 1 167721924291., 0000002.00, 20051129 3 476184123170., 0000002.00, 20050807 1 591235603972., 0000002.00...
  11. dunk2

    Count the occurrence of different field values.

    Hi, I want to count the occurrence of a different values in the second field of a file. Here's an example of the file'Vch_Head_NotSorted' ; 022276896167., 0000100.00,20050807 009377980266., 0000200.00,20050807 085142882117., 0000300.00,20050807 049156298766., 0001000.00,20050807...
    • dunk2
    • Thread
    • Replies: 4
    • Forum: AWK
  12. dunk2

    search file1 rows for file2 rows, if yes then remove rows

    Hi, I a large file1. I want to search it for lines that contain the same value in file2. If the values match then remove the row from file 1. Example of file1 5937000862 |414160|"SP"|"S"|"PRUEBAS"||20011025|+0000024.13|20011024|932 5937000000...
    • dunk2
    • Thread
    • Replies: 3
    • Forum: AWK
  13. dunk2

    to add all the digits after the 3rd place

    select sum(row_name - floor(row_name*1000)/1000) from table_name go
  14. dunk2

    select a field from a column

    Hi, How do I select a field from a numeric column? Example. I want to sum the fourth digit after the decimal place, typical number= 26.2345 so I want to select '5' and then sum this. Thanks in advance.

Part and Inventory Search

Back
Top