How do I cut out this field?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How do I cut out this field?
# 8  
Old 11-14-2008
Hammer & Screwdriver The following is a trick I sometimes use

Code:
> cat file67
joe
joe
joe
henry
henry
isabelle
monique
monique
nicole
nicole
nicole
nicole

> sort file67 | sed "s/^/,/" | uniq -c
      2 ,henry
      1 ,isabelle
      3 ,joe
      2 ,monique
      4 ,nicole

A couple of good things come out of this:
(1) there is now a comma between fields to allow easier extraction
(2) the output, if saved to a file, can be opened by Excel as a csv file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Cut the first field and the 2 last field

Hello, I would like to cut the first field and the 2 last fields from the string.Please help. Here is the example of the string.DL_FUND_FULL_20190605.txt DL_FUND_HIS_DEL_20190605.txt DL_FUND_HIS_TMP_DEL20190605.txt Please noted that DL_ --> Every files have the prefix like this.... (3 Replies)
Discussion started by: palita2601
3 Replies

2. Shell Programming and Scripting

how to cut the last field without using awk

i have file as with the below content aaa.bbb.cc.dd aaa.fff.bb yyyyy.rrrrr.ggggg.iii wwww.w.r.ty i want the o/p as below dd bb iii ty but i dont want to use awk. is there any other way to do this ? (5 Replies)
Discussion started by: anandgodse
5 Replies

3. Shell Programming and Scripting

Cut third field of every third line

Hello, I have got a log file and would need to write a script to cut the every first and second fields of every third line. Job Name : dummytextd_v1 Status : KILLED TIMEDOUT 2011-05-01 05:33 Job Name : dummyttx_v1 Status : KILLED TIMEDOUT 2011-05-03 02:33 Job Name :... (4 Replies)
Discussion started by: Kochappa
4 Replies

4. Shell Programming and Scripting

how to cut a particular field

hi all i am need to cut the name of the file which i am entering in the comand line. say abc.txt is the name of the file i need to cut only the "abc" part. when i try doing this(using cut -f1) i am getting the data that s present inside the file and the file name. pls help.... (3 Replies)
Discussion started by: din_annauniv
3 Replies

5. Shell Programming and Scripting

cut a field, but with reverse order

Hi Everyone, I have one a.txt: a b 001 c b b 002 c c c, not 002 c The output should be 001 002 002 If i use cut -f 3 -d' ', this does not work on the 3rd line, so i thought is any way to cut the field counting from the end? or any perl thing can do this?:confused: ... (3 Replies)
Discussion started by: jimmy_y
3 Replies

6. UNIX for Advanced & Expert Users

Printing Field with Delimiter in AWK/cut

Hello, I had posted earlier about printing fields using AWK, but now I have a slightly different problem. I have text files in the format: 1*2,3,4,5 and wish to print the first, third, and fifth fields, including the asterisk and commas. In other words, after filtering it should look... (1 Reply)
Discussion started by: Jahn
1 Replies

7. Shell Programming and Scripting

Cut portion of a field in shell scripts

Hi, I am a file with the following layout. field1|field2|field3|field4|field5|field6|field7 field1|field2|field3|field4|field5|field6|field7 field1|field2|field3|field4|field5|field6|field7 I need to write a file with the below layout field1|field2|fieldx|field6 where fieldx =... (5 Replies)
Discussion started by: shivacbz
5 Replies

8. Shell Programming and Scripting

Cut the last field

Hello guys. Is there any way I can cut the last field using "cut" ??? (without putting it into a while...) Thanks. 435 Gavea. (9 Replies)
Discussion started by: 435 Gavea
9 Replies

9. Shell Programming and Scripting

Cut last Field

Guys, I have a line like this: 109;201;1099010 and as you see that first field 109 and the last field starts with 109. I need to cut the rest in the last field after 109 which is 9010 How to do it? (2 Replies)
Discussion started by: sfaqih
2 Replies

10. UNIX for Dummies Questions & Answers

how to use cut to get the last field of a string?

If I am not sure of how many fields a string has, say STR=/homt/root/dir1/dir2/../dirn how to use "cut -d/ -f" to get dirn ? (3 Replies)
Discussion started by: meili100
3 Replies
Login or Register to Ask a Question
resize(1X)							     MIT X11R4								resize(1X)

Name
       resize - utility to set TERMCAP and terminal settings to current window size

Syntax
       resize [-u] [-s [row col]]

Description
       The  uitility  prints  a  shell command for setting the TERM and TERMCAP environment variables to indicate the current size of xterm window
       from which the command is run. For this output to take effect, resize must either be evaluated as part of the command  line  (usually  done
       with  a	shell alias or function) or else redirected to a file which can then be read in. From the C shell (usually known as /bin/csh), the
       following alias could be defined in the user's .cshrc:

	   % alias rs 'set noglob; `eval resize`'

       After resizing the window, the user would type:

	   % rs

       Users of versions of the Bourne shell (usually known as /bin/sh) that do not have command functions will need to send the output to a  tem-
       porary file and the read it back in with the ``.'' command:

	   $ resize >/tmp/out
	   $ . /tmp/out

Options
       The following options may be used with resize:

       -u      This option indicates that Bourne shell commands should be generated even if the user's current shell is not /bin/sh.

       -c      This option indicates that C shell commands should be generated even if the user's current shell is not /bin/csh.

       -s [rows columns]
	       This option indicates that the Sun console escape sequences will be used instead of the special xterm escape code. If rows and col-
	       umns are given, resize will ask the xterm to resize itself. However, the window manager may choose to disallow the change.

Restrictions
       The -u or -c must appear to the left of -s if both are specified.

       There should be some global notion of display size; termcap and terminfo need to be rethought in the context of window systems.	(Fixed	in
       4.3BSD, and ULTRIX-32 1.2)

Files
       For the base termcap entry to modify.

       User's alias for the command.

See Also
       csh(1), tset(1), xterm(1X)

																	resize(1X)