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 Wanet Telecoms Ltd 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
  • Content: Threads
  • 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, 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
  3. 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
  4. 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
  5. 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
  6. dunk2

    to add all the digits after the 3rd place

    select sum(row_name - floor(row_name*1000)/1000) from table_name go
  7. 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