Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Probably easy question for handy person!!!

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Probably easy question for handy person!!!
# 1  
Old 03-20-2006
Question Probably easy question for handy person!!!
I have given file with three columns,example:

mm234 5 22
mn237 6 45
de987 4 41

I have to check for input values in second and third column and if it is not numeric I have to deleted using grep function. I keep trying. But help from pros might help me.
We know that there is only one delimiter between columns!
Thanks for help.

Lube.
# 2  
Old 03-21-2006
Show us what you tried.
# 3  
Old 03-21-2006
ljubayuu
Hello there again, this is code I am having so far:
grep '.[[:space:]][0-9][[:space:]][0-9][0-9]$' $studentGrades > file5
grep '.[[:space:]][0-9][[:space:]][0-9][0-9][0-9]$' $studentGrades >> file5

I am wondering if it is possible to somehow write this two lines of code using only one line, I mean to combine them somehow into one.
Thanks!!!
# 4  
Old 03-22-2006
This should do.
Code:
sed -n -e 's_^[^ ]* [0-9][0-9]* [0-9][0-9]*_&_p' input.txt > output.txt

# 5  
Old 03-23-2006
I always prefer awk for greater control and further extensibility
awk ' { x=$1;
if($2~/^[[:digit:]]*$/) x=x" "$2;
if($3~/^[[:digit:]]*$/) x=x" "$3 ;
print x} ' a
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Should be an easy GREP question...

Two things. 1. I need to list all the jpg that start with a specific pattern and I tried using wildcards and can't get it to work. Basically: grep "cpd*.jpg" myfile.sgm return all entries that start with cpd (wildcard) and jpg but this does not work and I can't find another option--I'm... (4 Replies)
Discussion started by: jcor826
4 Replies

2. Shell Programming and Scripting

Easy VI Question (I hope)

Hi, I've FTPed some text files from windows to my Linux workstation. I'm finding that the characters for quotes (") have been replaced with control characters <93> and <94>. and apostrophes (') have been replaced with what looks like control character <92>. I have attempted the following... (15 Replies)
Discussion started by: larryjmoon
15 Replies

3. Shell Programming and Scripting

Easy cat question

I am having problems getting a list of filenames that I want from a directory. example: I have 3 files - filename.xxx.20110505.123030 filename.yyy.20110505.123030 filename.zzz.20110505.123030 There may be multiple xxx,... (3 Replies)
Discussion started by: Drenhead
3 Replies

4. UNIX for Dummies Questions & Answers

easy question

Hi everybody: Could anybody tell me if I have several files which each one it has this pattern name: name1.dat name2.dat name3.dat name4.dat name10.dat name11.dat name30.dat If I would like create one like: name_total.dat If I do: paste name*.dat > name_total.dat (15 Replies)
Discussion started by: tonet
15 Replies

5. Shell Programming and Scripting

Hopefully an Easy Question

I have a file name in this format ABC_WIRE_TRANS_YYYYMMDD_00.DAT I need to cut out the _00 out of the file name everytime. It could be _00, _01,_02, etc .... How do I cut it out to look as follows? ABC_WIRE_TRANS_YYYYMMDD.DAT (6 Replies)
Discussion started by: lesstjm
6 Replies

6. Shell Programming and Scripting

Easy AWK question

Ive got some output in a file that looks exactly like this: 1 ----------- 1542 1 record(s) selected. How do I just extract that 1542 and drop it into another file or (preferrably) a variable (using a ksh script) (9 Replies)
Discussion started by: rdudejr
9 Replies

7. Shell Programming and Scripting

A easy question.

this is the simple question, please help me! the question is: how to send exactly 50 ICMP Echo request packets with 500 bytes of payload to 202.139.129.221? I tried to use ping -F 500 202.139.129.221, but it didn't work. Thanks! (6 Replies)
Discussion started by: kikikaka
6 Replies

8. UNIX for Dummies Questions & Answers

Another easy question

Hello Again, Ok guys. Thanks again for your help last time but I am in need of your experience again. I wrote this script: #!/bin/sh # List either files or directories in individual accounts # using 1, 2 or 3 with invalid case $1 in echo select 1 to see the FILES in your... (3 Replies)
Discussion started by: catbad
3 Replies

9. UNIX for Dummies Questions & Answers

easy question

I know the Sun Solaries versions are ( 2.3 , 2.4 , 2.5 ... 7 , 8 ) . But some times I see sun os v5.x what does it mean ?? also what is the last new machine for sun and what are its details specifications . Thanks (3 Replies)
Discussion started by: tamemi
3 Replies

10. UNIX for Dummies Questions & Answers

Easy question

Hi, Simple question. How do I convert a unix text file to a dos text file? Thanks Helen (4 Replies)
Discussion started by: Bab00shka
4 Replies
Login or Register to Ask a Question