01-18-2007
Cut based on Two Delimiters at one go
Hi
I wanted to cut the feilds comming after % and After $ at one go
can we do some thing like this cut -f 2 -d "%|$" (But it doesnot work)
Input File
BWPG %TCPRP1 $SCSPR000
BWPH %TCPRP1 $SCSPR003
BWPI %TRTYUP ResourceDescription="IMPRIMANTE " $BWOPTY
BWPJ %ZOMBIE ResourceDescription="IMPRIMANTE " $XENTER
CWPJ %INTRA ResourceDescription="CAM 1ST 40121" $MENTER
CWPK %INTER ResourceDescription="CAM 2ND 40500" $SOZXI
Output
TCPRP1 SCSPR000
TCPRP1 SCSPR003
TRTYUP BWOPTY
ZOMBIE XENTER
INTRA MENTER
INTER SOZXI
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I just discovered, to my dismay, the following part of the cut man page:
-f, --fields=LIST
select only these fields;
also print any line that contains no delimiter character, unless the -s option is specified
The -s option toggles the printing of lines with no delimiters.
In most... (3 Replies)
Discussion started by: chlorine
3 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have a file which have set of rows and has to create separate files based on the id.
Eg:
001_AHaris020
001_ATony030
002_AChris090
002_ASmit060
003_AJhon001
Output: I want three files like 001_A.txt, 002_A.txt and 003_A.txt.
001_A.txt should have
... (1 Reply)
Discussion started by: techmoris
1 Replies
3. Shell Programming and Scripting
Hello,
I have data where words are separated by a delimiter. In this case "="
The number of delimiters in a line can vary from 4to 8. The norm is 4.
Is it possible to have a script where the file could be separated starting with highest number of delimiters and ending with the lowest
An... (8 Replies)
Discussion started by: gimley
8 Replies
4. Shell Programming and Scripting
Hi,
I have a problem to concatenate the lines based on number of delimiters (if the delimiter count is 9 then concatenate all the fields & remove the new line char bw delimiters and then write the following data into second line) in a file.
my input file content is
Title| ID| Owner|... (4 Replies)
Discussion started by: bi.infa
4 Replies
5. UNIX for Dummies Questions & Answers
Hi I have some data where each line will look something like this:
Time, name, i.d number, RB: 0.9949; RMQA: 0.0005; RB: 0.9951; RRA: 0.3; RA: 0.995; RA: 0.996; EA: 0.99105
etc.
I want to cut out all the RB: and RA:'s with the numbers after.
so in the above example i'd be left... (3 Replies)
Discussion started by: gvc
3 Replies
6. Shell Programming and Scripting
here below is sample string
null pointer dereference of 'resourceList' where null is returned from a method/opt/bld/fetch/ds/interzone/notification/LocalLineStatusNotificationListener.java:79
null pointer dereference of 'reList' where null is returned from a... (3 Replies)
Discussion started by: vivek d r
3 Replies
7. UNIX for Dummies Questions & Answers
I'm having bother getting both lines contained in a file to output as the same value.
A simple example:
john:123456:123:456:doe
john:123456:123:doe
cut -d: -f1,4 input file
john:456
john:doe ^ first line should be same as second.
trick one for me, i know why it's because of the... (4 Replies)
Discussion started by: landofus
4 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement where in I need to insert delimiters before the last column of the total delimiters is less than a specified number.
Say if the delimiters is less than 139, I need to insert 2 columns ( with blanks) before the last field
awk -F 'Ç' '{ if (NF-1 < 139)} END { "Insert 2... (5 Replies)
Discussion started by: arunkesi
5 Replies
9. Shell Programming and Scripting
When cut encounters consecutive delimiters it seems to count each instance as a field, at least with spaces. Is this typical behavior for any delimiter?
#:~$ ifconfig eth0 | grep HWaddr
eth0 Link encap:Ethernet HWaddr 94:de:80:a7:6d:e1
#:~$ ifconfig eth0 | grep HWaddr | cut -d " " -f... (6 Replies)
Discussion started by: Riker1204
6 Replies
10. Shell Programming and Scripting
BASH : I have a very long list I am parsing through:
10/10/19... (5 Replies)
Discussion started by: jeffs42885
5 Replies
LEARN ABOUT OPENDARWIN
cut
CUT(1) BSD General Commands Manual CUT(1)
NAME
cut -- select portions of each line of a file
SYNOPSIS
cut -b list [-n] [file ...]
cut -c list [file ...]
cut -f list [-d delim] [-s] [file ...]
DESCRIPTION
The cut utility selects portions of each line (as specified by list) from each file and writes them to the standard output. If no file argu-
ments are specified, or a file argument is a single dash ('-'), cut reads from from the standard input. The items specified by list can be
in terms of column position or in terms of fields delimited by a special character. Column numbering starts from 1.
The list option argument is a comma or whitespace separated set of increasing numbers and/or number ranges. Number ranges consist of a num-
ber, a dash ('-'), and a second number and select the fields or columns from the first number to the second, inclusive. Numbers or number
ranges may be preceded by a dash, which selects all fields or columns from 1 to the first number. Numbers or number ranges may be followed
by a dash, which selects all fields or columns from the last number to the end of the line. Numbers and number ranges may be repeated, over-
lapping, and in any order. It is not an error to select fields or columns not present in the input line.
The options are as follows:
-b list
The list specifies byte positions.
-c list
The list specifies character positions.
-d delim
Use the first character of delim as the field delimiter character instead of the tab character.
-f list
The list specifies fields, delimited in the input by a single tab character. Output fields are separated by a single tab character.
-n Do not split multi-byte characters.
-s Suppress lines with no field delimiter characters. Unless specified, lines with no delimiters are passed through unmodified.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of cut if the -n option is specified. Their effect is described in
environ(7).
EXAMPLES
Extract users' login names and shells from the system passwd(5) file as ``name:shell'' pairs:
cut -d : -f 1,7 /etc/passwd
Show the names and login times of the currently logged in users:
who | cut -c 1-16,26-38
DIAGNOSTICS
The cut utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
paste(1)
STANDARDS
The cut utility conforms to IEEE Std 1003.2-1992 (``POSIX.2'').
HISTORY
A cut command appeared in AT&T System III UNIX.
BUGS
The -c option is a synonym for the -b option, which causes incorrect behaviour in locales that support multibyte characters.
When operating on fields (-f option is specified), cut does not recognise multibyte characters, and the delim character is recognised in the
middle of multibyte sequences.
BSD
June 6, 1993 BSD