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...
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...
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...
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...
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...
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...
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 >...
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...
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...
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 [...
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...
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...
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...
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...
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]...
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...
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...
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...
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:"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.