dummy question on data process


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers dummy question on data process
# 1  
Old 11-13-2008
Question dummy question on data process

I have a file which contains 6 columns.
But I only need the first 3 columns. So I need to remove the last 3 columns. I checked 'cut' but it seems not working.
So is there a command that could remove certain columns from a file? Smilie
Thanks a lot!!
# 2  
Old 11-13-2008
That's what I would use:
Code:
awk '{printf("%s %s %s\n",$1,$2,$3)}'

nawk instead of awk under Solaris.

Cut does work too:

Code:
cut -d" " -f1-3

# 3  
Old 11-13-2008
thanks !!! :-)))))))))
# 4  
Old 11-14-2008
one more dummy question, what if I want to keep column 1 and column 3, but remove column 2 and column 4?? I mean, can I still use cut -f ?? ( or i need to use awk, which I don't really understand... )
# 5  
Old 11-14-2008
Almost the same one:
Code:
cut -d" " -f1,3

# 6  
Old 11-14-2008
really appreciate SmilieSmilieSmilie

Quote:
Originally Posted by jlliagre
Almost the same one:
Code:
cut -d" " -f1,3

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Dummy Question

Where can I get UNIX? (1 Reply)
Discussion started by: ciao303
1 Replies

2. UNIX for Dummies Questions & Answers

Dummy question on awk

Hi, I have a file which has three columns and 200 rows. I would like to print an extra column say "disco" for every 10 th row starting from 4 th row. How is that possible? Thnx (4 Replies)
Discussion started by: Indra2011
4 Replies

3. IP Networking

DNS dummy question

Hello everyone, I have a some doubt about DNS. We have connected to 2 ISPs /ISP#1 and ISP#2/. Our web site's dns zone is located on ISP#1. If connection to ISP#1 is down clients won't find our website. ISP#1 connection went down few times this month. So we are going to create our website's... (0 Replies)
Discussion started by: sembii
0 Replies

4. UNIX for Dummies Questions & Answers

a dummy question on data processing

Hi, everyone, I have a matrix, let's say: 1 2 3 4 5 6 ... 4 5 6 7 8 9 ... 7 8 9 1 2 3 ... 3 4 5 6 7 8 ... ......... (nxm matrix) Is there a simple command that can take certain specific rows out of the matrix? e.g., I want to take row 2 (4 5 6 7 8 9 ...) and row 4 (3 4 5 6 7 8... (2 Replies)
Discussion started by: kaixinsjtu
2 Replies

5. UNIX for Dummies Questions & Answers

a dummy question...needs help...

I am trying to use 'cut' to get a line from my file. But it seems that 'cut' recongnizes TAB as default. My file uses space instead. So 'cut' doesn't work. Anybody can tell me how to change the default from TAB to space ? Or how to transform a space-delimited file into tab-delimited file??... (2 Replies)
Discussion started by: kaixinsjtu
2 Replies

6. Shell Programming and Scripting

how to plug dummy data into zero byte file?

Hi, How can I plug dummy data into files that are zero bytes ? Here is a sample script for removing the files I think. find /path/to/directory -size 0 -type f -exec rm -f {} \; I am not sure how to change it to echo "dummy" > zerobyte.txt. Any suggestions? Here's the farthest I got:... (2 Replies)
Discussion started by: ihot
2 Replies

7. UNIX for Advanced & Expert Users

How to create a dummy process of a process already running?

Hi Everybody, I want to create a shell script named as say "jip" and it is runned. And i want that when i do ps + grep for the process than this jip should be shown as process. Infact there might be process with name jip which is already running. (3 Replies)
Discussion started by: shambhu
3 Replies

8. Filesystems, Disks and Memory

A simple dummy question

Hello Everyone! changing from Microsoft to Macintosh, I connected my hard disk (nearly full) to the apple computer, which could not recognize it. I was prompt to "initialize it", unfortunately I DECIDED YES!!, but just for 1/100 of a second: now I cannot access the hard disk at all. Is still... (1 Reply)
Discussion started by: NETTO68
1 Replies

9. UNIX for Dummies Questions & Answers

question from a dummy

okay so I just started this unix class and understood all the test questions but this "normal" question threy me through a loop :confused:. The question is Why are UNIX commands noninteractive and why is their output not usually preceededby header information? This question has been driving me... (2 Replies)
Discussion started by: cinnamonbear
2 Replies

10. UNIX for Dummies Questions & Answers

Unix dummy's question

:confused: Hi, 2 questions to get some insight. Thanks (1) I would like to add a prefix (XX00) in each row of the line in my text file and save a newly generated file another name. How to go about it. (2) How to insert a blank line into each row in my file. and save the file another name.... (2 Replies)
Discussion started by: merry susana
2 Replies
Login or Register to Ask a Question