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?
# 1  
Old 11-14-2008
How do I cut out this field?

Hello,

In a shell script I am writing I execute this command:

uniq -c names1.tmp > names2.tmp

In names2.tmp I get these results:

4 user
2 username
1 users
1 veriano
1 victoria

I need to isolate the names in this file and put it in another file. However it seems that the number and name are considered one field, f7 so I cannot seem to use the cut command to get the names. Any ideas on how I can do so?
# 2  
Old 11-14-2008
Code:
cut -d" " -f 2 infile > outfile

# 3  
Old 11-14-2008
Quote:
Originally Posted by zaxxon
Code:
cut -d" " -f 2 infile > outfile


It's not working. I get nothing. The only difference here is you declared the delimiter before the field but the result is the same.... I have cut and paste the file I need to work on below. As you can see there is a huge tab. For some reason the number and name are considered field 7. When I cut f 7 I get the number and name. I hope someone can help me solve this strange problem.

1 Aaliyah
1 Aaron
1 Aba
1 Abel
1 Amanda
1 Andrew
1 Ashley
1 Beavis
1 Buster
1 Cowboys
1 Dakota
1 Dallas
1 Dolphin
1 Friends
1 George
1 Hatton
1 Hockey
1 Internet
1 Jessica
1 Jewel
1 Jordan
1 Justin
2 Maddock

I am using the following:

# cut --version
cut (coreutils) 5.0
Written by David Ihnat, David MacKenzie, and Jim Meyering.

Copyright (C) 2003 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Last edited by mojoman; 11-14-2008 at 11:22 AM..
# 4  
Old 11-14-2008
I can't see any tabs. Check your post. You can post code and logs etc. inside [ code ] and [ /code ] tags so most formatting won't get list.
Also by what you present as input, I can't see any field number 7. All I see is 2 fields per row, considering the space is the field separator.

Try to post your input and desired ouput with all field and tabs etc. so we can give a working example.
Without seeing your real input/desired output, you could check to extract the wanted fields maybe with awk, assuming that the field separator is any kind of blank/space/tab and that you have at least 7 fields per row/line:
Code:
awk '{print $7}' infile

# 5  
Old 11-14-2008
Quote:
Originally Posted by zaxxon
I can't see any tabs. Check your post. You can post code and logs etc. inside [ code ] and [ /code ] tags so most formatting won't get list.
Also by what you present as input, I can't see any field number 7. All I see is 2 fields per row, considering the space is the field separator.

Try to post your input and desired ouput with all field and tabs etc. so we can give a working example.
I am as dumbfounded as you are.

Like I said I execute the following command: uniq -c names1.tmp > names2.tmp

names1.tmp is as follows (partial listing):

Code:
griselda
gsm
gsm
gsm
guest
guest
guest
guest
guest
guest
guest
guest
guest
guest
hammer
happy
harley
hayashi

We get names2.tmp (partial listing):

Code:
      1 Aaliyah
      1 Aaron
      1 Aba
      1 Abel
      1 Amanda
      1 Andrew
      1 Ashley
      1 Beavis
      1 Buster
      1 Cowboys
      1 Dakota
      1 Dallas
      1 Dolphin
      1 Friends
      1 George
      1 Hatton
      1 Hockey
      1 Internet
      1 Jessica
      1 Jewel
      1 Jordan
      1 Justin
      2 Maddock

So you see there is a large indent on the left. When I execute the cut command command on f2 I get nothing. When I execute on f7 I get the following which is weird:

Code:
1       Abel
1       Amanda
1       Andrew
1       Ashley
1       Beavis
1       Buster
1       Cowboys
1       Dakota
1       Dallas
1       Dolphin
1       Friends
1       George
1       Hatton
1       Hockey
1       Internet
1       Jessica
1       Jewel
1       Jordan
1       Justin
2       Maddock

cutting on f2 yields nothing....
# 6  
Old 11-14-2008
Hehe, assuming I can see it now, but I still can't see field number 7 or what you understand by f7, try out:

Code:
awk '{print $2}' infile

If that is what you are looking for, redirect it in the desired file.
# 7  
Old 11-14-2008
Quote:
Originally Posted by zaxxon
Hehe, assuming I can see it now, but I still can't see field number 7 or what you understand by f7, try out:

Code:
awk '{print $2}' infile

If that is what you are looking for, redirect it in the desired file.
Do you want to know something weird? I left out the -d option for delimiter and I ran

cut -f2 names2.tmp ...guess what? I got the right answer:

Code:
undead
unix
up
upload
user
username
users
veriano
victoria
walter
wayne
web
webadm
webadmin
webdev
webmaster
webpop
welcome
wheeling
willow
wizard
www
www-data

Comments?
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