Search results for query: *

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

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

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

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

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

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

Thanks guys, that worked a treat.

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?

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

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

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

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

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

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.