08-02-2005
Cutting the top two lines, and also charachters below.
Hey all. I have a file that I am trying to cut information out of. We have a script that shows us all of our Radio Scanners that are being used and I'm writing a script that clears all of the context off of the scanners. The script that runs shows us this information below...
|emp_id |first_name|last_name |base_unit|radio_id|
|---------|----------|--------------------|---------|--------|
|S990CA2 |CORY |AUKERMAN | 1| 66|
|S990LR4 |LARRY |ROGERS | 1| 67|
|S990EF1 |ELIZABETH |FREDRITZ | 1| 69|
|S990JG7 |JARED |GEORGE | 1| 70|
|S990SM9 |SANTOS |MELCHOR JR. | 1| 71|
|S990RB8 |RONNIE |BOWLIN | 1| 73|
|S990MW3 |MEGAN |WARE | 1| 74|
|S990ML1 |MICHAEL |LOWERY | 1| 75|
|S990HW2 |HAMER |WOLFE | 1| 77|
|S990RB13 |RAY |BYERLY | 1| 81|
|S990DM3 |DEAN |MULVAINE | 1| 82|
|S990JH3 |JAY |HARTMAN | 1| 84|
The only info that I need are emp_id and the Radio_id. The only problem is, I don't know how to cut the top 2 or 3 lines to erase the headers. I have the characters that I need cut out just fine, but I'm not so sure about the top 2 lines. Any help would be great.
Thanks a lot.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Happy New Year!!!
I'm trying to cut out some text in a data file where I only want the first line and the last line.
For example.
1. Colin Was here <<-- Text I want to cut out
2. THIS IS THE TEXT I WANT TO CUT <- CUT THIS OUT
3. OUT BECAUSE IT'S NO GOOD TO ME <- CUT THIS OUT
4. I... (5 Replies)
Discussion started by: cfoxwell
5 Replies
2. UNIX for Dummies Questions & Answers
Can anyone tell me what the charachter maximum on a username is in SunOs 5.6.
Thanks
Mark (1 Reply)
Discussion started by: m.szylkarski
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have this problem of separating 10 consecutive lines from a file, say starting from 21 to 30... I have used a filter like this..
head -n 30 myfile | tail -n 10
Is there a simpler way than this? (2 Replies)
Discussion started by: Vishnu
2 Replies
4. Shell Programming and Scripting
HI All,
I want to cut 5 lines after a pattern using sed or awk. can any one tell me how to do it ? (2 Replies)
Discussion started by: raghin
2 Replies
5. Shell Programming and Scripting
Hi,
I have a file named Mani.txt. The contents are like this
cat Mani.txt
--------------------------------------------------------
Hi there how r u
My Name is Mani
Bye
------------------------------------------------------------
I want to cut the first and last lines from the file... (15 Replies)
Discussion started by: pathanjalireddy
15 Replies
6. Shell Programming and Scripting
Dear All,
Is there a way to cut the lines that have been "head"
Here is what i m trying to do Please advice
there is file name dummy.txt
now i am trying to head this file 4 time by using a loop and every time this file is head with different values
e.g in first instance it will... (7 Replies)
Discussion started by: jojo123
7 Replies
7. Shell Programming and Scripting
Please see the following code, between "status" and "OK" exists many spaces, I want to get status OK . how to ignore multi spaces? If tab exists in the spaces, how to ignore it ?
Is there other commands can replace cut?
$ echo 'drv status OK'| cut... (3 Replies)
Discussion started by: 915086731
3 Replies
8. UNIX for Dummies Questions & Answers
Hi.
I am not sure how to solve this problem and if it is possible to do so with scripting. :wall:
Let's say I have this data:
A 12345 12360
A 12359 12380
A 12381 12390
A 12400 12450
A 12451 12460
B 23456 23460
B 23470 23480
B 23477 23505
I wan't each line to be compared in this... (5 Replies)
Discussion started by: danieladna
5 Replies
9. Shell Programming and Scripting
Oracle Linux 6.4
In a directory I have more than 300 files with the extension .log
I want the first 5 and last 5 lines of these .log files to be printed on screen with each file's name.
Expected output :
Printing first 5 and last 5 lines of FX_WT_Feb8_2014.log
!! Authentication... (7 Replies)
Discussion started by: kraljic
7 Replies
10. UNIX for Dummies Questions & Answers
I am trying to remove columns 81-97 from a line that can be as long as 114 characters. Because a number of lines might not have under 80 characters, using the cut command following by paste could be a problem. While sed might work, is there some other utility that could do this more easily?
... (9 Replies)
Discussion started by: wbport
9 Replies
LEARN ABOUT OPENSOLARIS
cut
cut(1) User Commands cut(1)
NAME
cut - cut out selected fields of each line of a file
SYNOPSIS
cut -b list [-n] [file]...
cut -c list [file]...
cut -f list [-d delim] [-s] [file]...
DESCRIPTION
Use the cut utility to cut out columns from a table or fields from each line of a file; in data base parlance, it implements the projection
of a relation. The fields as specified by list can be fixed length, that is, character positions as on a punched card (-c option) or the
length can vary from line to line and be marked with a field delimiter character like TAB (-f option). cut can be used as a filter.
Either the -b, -c, or -f option must be specified.
Use grep(1) to make horizontal ``cuts'' (by context) through a file, or paste(1) to put files together column-wise (that is, horizontally).
To reorder columns in a table, use cut and paste.
OPTIONS
The following options are supported:
list A comma-separated or blank-character-separated list of integer field numbers (in increasing order), with optional - to indi-
cate ranges (for instance, 1,4,7; 1-3,8; -5,10 (short for 1-5,10); or 3- (short for third through last field)).
-b list The list following -b specifies byte positions (for instance, -b1-72 would pass the first 72 bytes of each line). When -b and
-n are used together, list is adjusted so that no multi-byte character is split.
-c list The list following -c specifies character positions (for instance, -c1-72 would pass the first 72 characters of each line).
-d delim The character following -d is the field delimiter (-f option only). Default is tab. Space or other characters with special
meaning to the shell must be quoted. delim can be a multi-byte character.
-f list The list following -f is a list of fields assumed to be separated in the file by a delimiter character (see -d ); for
instance, -f1,7 copies the first and seventh field only. Lines with no field delimiters will be passed through intact (useful
for table subheadings), unless -s is specified.
-n Do not split characters. When -b list and -n are used together, list is adjusted so that no multi-byte character is split.
-s Suppresses lines with no delimiter characters in case of -f option. Unless specified, lines with no delimiters will be passed
through untouched.
OPERANDS
The following operands are supported:
file A path name of an input file. If no file operands are specified, or if a file operand is -, the standard input will be used.
USAGE
See largefile(5) for the description of the behavior of cut when encountering files greater than or equal to 2 Gbyte (2^31 bytes).
EXAMPLES
Example 1 Mapping user IDs
A mapping of user IDs to names follows:
example% cut -d: -f1,5 /etc/passwd
Example 2 Setting current login name
To set name to current login name:
example$ name=`who am i | cut -f1 -d' '`
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of cut: LANG, LC_ALL, LC_CTYPE, LC_MES-
SAGES, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 All input files were output successfully.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO
grep(1), paste(1), attributes(5), environ(5), largefile(5), standards(5)
DIAGNOSTICS
cut: -n may only be used with -b
cut: -d may only be used with -f
cut: -s may only be used with -f
cut: cannot open <file>
Either file cannot be read or does not exist. If multiple files are present, processing continues.
cut: no delimiter specified
Missing delim on -d option.
cut: invalid delimiter
cut: no list specified
Missing list on -b, -c, or -f option.
cut: invalid range specifier
cut: too many ranges specified
cut: range must be increasing
cut: invalid character in range
cut: internal error processing input
cut: invalid multibyte character
cut: unable to allocate enough memory
SunOS 5.11 29 Apr 1999 cut(1)