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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
alert if email not received in outlook
Hi, not sure where the right place is for this post but if anyone has any ideas then please share :) I have a matlab script that runs daily and sends an email to show the results (the position of a buoy in the sea). If the matlab script fails - this is recorded in the email, however, if the...- rhnaeco
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
unchangable low resolution
Hi, Fedup of waiting half an hour for my dell mobile workstation to load up i removed some unused programs from the startup options in msconfig. When it restarted it came up with the usual ms panic and very low resolution. I couldn't change the resolution so i just went back to the normal...- rhnaeco
- Thread
- Replies: 3
- Forum: Microsoft: Windows
-
-
use column as variable
Thanks PHV, but i still can't get it to work. My layout is slightly different now (bin, ensemble, data....) so i've used: for(i=1;i<=(1+$1);++i)printf "%s,",$i;print $(2+$1) but all i get is extra blank space at the end and nothing removed. Can you offer further help? I've included the first... -
use column as variable
Hi, I have columns of data which are measurements of current flow in the water column. The instrument returns data from above the water column, which is data I want to remove (retain only data in the water, not any noise). my datafile (headers): ensemble, depth, 1, 2, 3, 4,... 34, 35, 36, 37... -
-
Substitute Line
I have lots of files with several hundred rows and columns. I would like to substitute one line and keep the others as is. For that line I would like to add 0.8 to each column input: a,s,d,f,g,h 1,2,3,4,5,6 ed,rf,hg,rt,fg,kj output: a,s,d,f,g,h 1.8,2.8,3.8,4.8,5.8,6.8 ed,rf,hg,rt,fg,kj but... -
excel function 'if true'
Hi all, this is my data: Range From To Sunrise Sunset 0.8 03:24 08:38 03:34:00 20:54:00 1 08:38 15:15 03:34:00 20:54:00 1.1 15:15 21:26 03:34:00 20:54:00 0.8 21:26 04:10 03:34:00 20:54:00 0.7 04:10 09:26 03:36:00 20:52:00 yes 0.9 09:26 16:06 03:36:00 20:52:00 0.9 16:06 22:18 03:36:00...- rhnaeco
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
average block of data
I haven't a clue really! I haven't used awk for a couple of years and so I am almost back to square one. I am currently trying to use the approach of converting the date and time into a number and then using a similar code to http://www.tek-tips.com/viewthread.cfm?qid=1329515 any ideas would be... -
average block of data
Hi, I have a file of burst data - i.e. data exists every 0.5 seconds for 1 minute, and then there is a 15 minute gap (approx) before any more data is printed. Can awk average the data (multiple columns) for each burst and print the line of averaged data to a new file? Input: 23/11/2008... -
calculate mode/ most common value
Thank you vlad, most apprieciated. rhnaeco -
calculate mode/ most common value
example file: a b 2 a b 2 a b 6 a b 2 a b 4 a b 2 a b 1 output: mode=2 -
calculate mode/ most common value
Hi, does anybody know how to calculate the mode using awk or sed? I have a 3 column file and i need to find the most common value in the 3rd column. thanks in advance rhnaceo -
if statement using arrays
thank you Annihilannic i found another way around this, but any help learning this program is always useful! only if you have the time... thanks again rhnaeco -
if statement using arrays
Hi, i need a bit of help sorting out my script: awk ' BEGIN { while (getline < "file1") { cnt[$1]=$1 dep[$1]=$2 } } { if (cnt[$1] = $1) if ((dep[$1] < $2+0.4) && (dep[$1] > $2-0.4)) print $1, $2, dep[$1], $3, $4 }' file2 > file3 lines from file1: 486 -0.35... -
find string and print preceeding and following lines
thank you - it works great! I kind of understand how it works but i do have one question/confirmation - what does the '%' mean in this context- i thought it was to do with decimal places but the results show 7dp rather than 5. google deosn't really like '%' as a search and i can't say i... -
find string and print preceeding and following lines
i can only see help for subsequent lines, not lines preceeding the label..... -
find string and print preceeding and following lines
hi, i have a data set of sonar pings. Each record consists of several lines of associate data such as depth and position and followed by 30 lines of actual data, followed by the next record. normally i would say something like ' if $1 = "line1" then print next 30 lines' and then sort it out... -
averaging column
Thanks Feherke, that explained it nicely- i was still none the wiser after wading through the awk man page! and thanks risby- i was definately on the right track if your answer is anything to go by, but i just couldnt 'join the dots ' so to speak. thanks again rhnaeco -
averaging column
thank you, thank you, thank you!! what does % do? (google is no help) this has been very frustrating for me as i had lots of components to this answer but couldn't for the life of me work out how they would all fit together! thanks again rhnaeco
