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 bkrike 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: littleIdiot
  • Content: Threads
  • Order by date
  1. littleIdiot

    Simple SELECT question

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

    DVD Software

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

    too many pipes, can you streamline this?

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

    tar -k size - how does it work?

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

    egrep "| N1" and "| N2" and "| N3" from file

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

    Capture screen output

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

    capture screen output (not tee, nor > )

    Hi, I am running a C program in UNIX that outputs info to the screen. I can not edit the source code, but want the output to be available to other users other than me. I have tried all of the following, all in csh (assuming "command" is the command run): command | tee -a file.log command >...
  8. littleIdiot

    count occurances and num of unique occurances

    Hi, I have a large flat text file, comma delim. There are 27 columns in the file. I want to do soemthing like this: for each [field 1] count occurances in [field 7] and count UNIQUE occurances in [field 7] So the output would be something like: ABC, 20, 2 DEF, 12, 3 meaning that...
  9. littleIdiot

    ftp 'hop' - 'get' then 'put' using 2 different servers

    Hi, Due to networking issues, I am having to do an ftp 'hop' to move data from one location to another, via an intermediary. i.e. location A contains original data, and I need to move it to location C: ftp data from loc.A to loc.B, then ftp from loc.B to loc. C I can do all work from...
  10. littleIdiot

    if - then checks on one line

    Hi, Simple question - I'm tidying up some scripts to make them more "readable" and was trying to change the following code. All it is meant to do is check that the user has entered valid file names and directory names when running the script from command line. 'm trying to change this: if [...
  11. littleIdiot

    check var has chars in it - i want int only

    Hi, I am using the 'cut' command to take a column of data out of a file and then need to process the results. However the results need to be integers, and some of the values have text characters in. I need to take all integers from the left of my output. Example output: 88PL 69 88PL 70...
  12. littleIdiot

    SUMPRODUCT gives #NAME? error

    Hi, I have a WorkBook that I created in Excel 2000 that uses SUMPRODUCT. When I opent he Workbook on another machine using Excel 2002, the SUMPRODUCT results fail (along with the WEEKNUM result). When I say fails, I mean I get a #NAME? error. I have checked my array definitions and they seem...
  13. littleIdiot

    check for numbers in a string

    Hi, I am in the middle of a script and need to check if one of my variables has numbers in it. I tried explaing why but it didn;t makes sense so hopefully just pasting my code will explain in itself: #FIELD5 and DC are text variables # check if FIELD5 is DC.1.rode, DC.2.rode etc...
  14. littleIdiot

    ls -l | sort on 1st and then 3rd field

    Hi, I have a series of files on disk that I am trying to list sorted by the 1st, then the 3rd field (field delim being a full stop/period ".") For example: C00014403.txt.1 C00014403.txt.2 C00014403.txt.3 C00014403.txt.4 C00014403.txt.5 C00014403.txt.6 C00014404.txt.1 C00014404.txt.2...
  15. littleIdiot

    Multiple "Not like" Query

    hi, Simple one: I have two large tables joined by a query. I wish to EXCLUDE certain values in a specific field. So far I have come up with the folowing: AND ( ( EGIS_EXPORT.[Kind Cd] ) Not Like "ACQPD" ) AND ( ( EGIS_EXPORT.[Kind Cd] ) Not Like "ACQSUP" ) AND ( ( EGIS_EXPORT.[Kind Cd]...
  16. littleIdiot

    Enter multiple filenames into 'stage' command

    Hi, Any one know how to feed in a list of file names into the stage command rather than give an entire directory? If you do no know what 'stage' is (like me!), basically I'm trying to create a script that takes a list of file names that are contained in an input file: file1.txt file_a.txt...
  17. littleIdiot

    How to tell if script is still running

    Hi, I have a script that, no matter how many catches and fail-safe's I put itno it, will sometimes hang due to the data I am dealing with. I have to Ctrl+C out of it when it hangs. I have tried many ways of catching this before it happens but it is not possible in some instances. I am looking...
  18. littleIdiot

    grab permstring and file name from ls -la

    I need to pass a ls -al output and grab just the: . permission string . month . day . swing (time/year) . filename This seems to be failing: $line is the entire line, e.g. -rw------- 1 sam samadm 11 Feb 17 15:19 file.txt echo "$line" | IFS=" " read permstring junk junk junk...
  19. littleIdiot

    simple "if" command question

    I can't believe I'm struggling with this - I can't work out why it isnt working ... The script I have entered bleow is not the script I am working on - I have writte it to show what I am trying to do: #!/bin/ksh #set -vx # # Check number of parameters if [ $# -lt 1 ] then echo "Usage:"...
  20. littleIdiot

    AWK - Counting 3 columns, 1000;s records

    Ok - I am an AWK novice, and can just about use single line commands to do what I need, but I have now come up against a challenge and I don't have tme to learn AWK to work out how to do it. I'm hoping someone here can help me out. I have a file that is composed of ~500,000 rows and 3 columns...

Part and Inventory Search

Back
Top