Search results for query: *

I use semi-colon (;) to close ... and yes, it seems it needs old style joins ... this worked: select distinct BARCODE, PROJECT from DATACARRIER, SEIS_DISCRIPTION where DATACARRIER.IDX = SEIS_DISCRIPTION.IDX and LINE like 'U3%'; Thanks for your help!

this might be easier to read: SQL> select distinct IDX, BARCODE, PROJECT 2 from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX = SEIS_DISCRIPTION.IDX 3 where LINE like 'U3%'; from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX = SEIS_DISCRIPTION.IDX *...

Thanks ... but it failed and I'm not sure why ... SQL> select distinct IDX, BARCODE, PROJECT from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX = SEIS_DISCRIPTION.IDX where LINE like 'U3%'; select distinct IDX, BARCODE, PROJECT from DATACARRIER join SEIS_DISCRIPTION on DATACARRIER.IDX =...

Will this work as I think it should? select unique IDX, BARCODE, PROJECT from DATACARRIER where IDX in (select idx from SEIS_DISCRIPTION where LINE like 'U3%'); thanks

Hi, I'm sure this is easy to do - but I'm still building my knowledge as I work so turning to trusty tek-tips forums for help ... Table 1: SEIS_DISCRIPTION SEIS_DISCRIPTION Null? Type ------------------------------- ---- IDX NUMBER FORMAT VARCHAR2(6) START_CDP NUMBER...

Thanks I use infrarecorder at home - couldn;t get it to do what I want it to do - maybe I need to look into setting a bit more. I'll look at Roxio - think I have that at home. Will check tonight. Thanks - any other suggestions welcome!

Not sure if I'm in the right place but here goes anyway ... I'm looking to burn all my MP3's to DVD as mp3's, in their current directory structure. But it's about 29GB worth of data. I want some software that allows me to just say "Burn that lot to DVD and if it goes over one DVD, then let me...

Ammendment: If the output is able to have the OPTION of outputing the part I want (first part of the filename, without underscore or "." extension) AS WELL AS the full file path, as a QC method. I note that my output has some dodgy results, and to check it, I would need to know what the...

Hi, I have never got to grips with how to use awk in any way other than one liners - when people show me more complicated awk scripts they never seem tomkae much sense to me. But now I have created a daft "one liner" and want to see if any one can a) streamline it so that it's not just a series...

Should have mentioned, I'm stuck on SunOS 5.8 ... :o(

Hi, I have been presented with a large (200GB) tar file, and I am trying to reduce it to manageable(2GB) chunks, without corrupting the data contained within. I could use "split" to split it up, but then each individual file is useless, and relies on being able to create a 200GB file on future...

Ah ha - that works ... egrep "\| N1|\| N2" pipe_delim.txt Many thanks (yet again) to PHV

sorry - strings2.txt should be strings.txt I have tried it with "| N1" and | N1

Thanks - but no joy ... % more strings2.txt | N1 | N2 | N3 | N4 | N5 | N6 | N7 | N8 | N9 % egrep -f strings.txt pip_delim.txt egrep: syntax error %

Hi, Simply really ... I have a pipe delimited text file and want to grep everything except the following text: | N1 | N2 | N3 | N4 | N5 | N6 | N7 | N8 | N9 I have searched the FAQ's and this forum, but not really getting anywhere. I think egrep and an input file listing my text will work...

Thanks for the help everyone. I have found that the script does in deed output to a log file upon redirection - but only after 10 minutes or so - I assume it is filing a buffer and only puging once the buffer is full. However this is probably good enough for our needs at the moment. I think...

Turns out the redirect WAS working all along - just not fillign the log file for about 10 minutes or so ... I assume it was filling a buffer then writnig to the log file and waiting again ... problem solved. Thanks all for your help.

Thanks for the reply. when I try redirection like that - or even the full file path of the compiled program, the log file is created but stays empty - and the program does not seem to run. Yes - redirection works normally for everything else.

Unsure if this is the right forum, but I already tried UNIX and got no-where, hoping this give me more ... I have a .c program I am running on Solaris. As the program runs, it writes text out to the terminal window. I want to capture this text in a log file so that other users can tail -f the...

Your help is appreciated. We use netmeeting regularly here - but it is stil not a solution, just a work around. It's very frustrating that the output is there on my screen but I can't log it ... Ah well ...