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)																resize(1X)

NAME
resize - set TERMCAP and terminal settings to current xterm window size SYNOPSIS
resize [-u] [-c] [-s[row col]] OPTIONS
The following options may be used with resize: This option indicates that Bourne shell commands should be generated even if the user's cur- rent shell is not /bin/sh. This option indicates that C shell commands should be generated even if the user's current shell is not /bin/csh. This option indicates that 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. DESCRIPTION
The resize command prints a shell command for setting the TERM and TERMCAP environment variables to indicate the current size of xterm win- dow 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 % 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 FILES
for the base termcap entry to modify. user's alias for the command. BUGS
The -u or -c must appear to the left of -s if both are specified. SEE ALSO
csh(1), tset(1), xterm(1X) AUTHORS
Mark Vandevoorde (MIT-Athena), Edward Moy (Berkeley) Copyright (c) 1984, 1985 by X Consortium See X(1X) for a complete copyright notice. resize(1X)