How to filter


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to filter
# 1  
Old 07-18-2011
Data How to filter

Hi I have a file containing the below lines

1010001001639
1010001001789
1020001001927
1030001001928
1040001002033
1200001002609
1200001003481
1200001004935

I need to filter lines that starts with 101.

It would be of great help if its in awk.
# 2  
Old 07-18-2011
Code:
awk '/^101/' file

# 3  
Old 07-18-2011
Thanks Bartus... Very kind of uSmilie

---------- Post updated at 12:41 PM ---------- Previous update was at 12:34 PM ----------

But the below is not working

for cc in 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 139
do
cat temp | awk '/^$cc/' >acc_$cc
done
# 4  
Old 07-18-2011
use this
Code:
awk '/^'$cc'/' temp >acc_$cc

instead of this
Code:
cat temp | awk '/^$cc/' >acc_$cc

This User Gave Thanks to pravin27 For This Post:
# 5  
Old 07-18-2011
Or..
Code:
STR=101
grep "^$STR" temp > acc_${STR}

# 6  
Old 07-18-2011
Quote:
Originally Posted by Naga06
Thanks Bartus... Very kind of uSmilie

---------- Post updated at 12:41 PM ---------- Previous update was at 12:34 PM ----------

But the below is not working

for cc in 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 139
do
cat temp | awk '/^$cc/' >acc_$cc
done
Use double quote instead of single:
Code:
for cc in 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 139
do
cat temp | awk "/^$cc/" >acc_$cc
done

# 7  
Old 07-18-2011
Quote:
Originally Posted by Naga06
Thanks Bartus... Very kind of uSmilie

---------- Post updated at 12:41 PM ---------- Previous update was at 12:34 PM ----------

But the below is not working

for cc in 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 139
do
cat temp | awk '/^$cc/' >acc_$cc
done

Instead of it, you can try:

PHP Code:
awk '{ s=substr($0,1,3); print >"acc_"s;}'  temp 
This User Gave Thanks to dennis.jacob For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Filter records in a huge text file from a filter text file

Hi Folks, I have a text file with lots of rows with duplicates in the first column, i want to filter out records based on filter columns in a different filter text file. bash scripting is what i need. Data.txt Name OrderID Quantity Sam 123 300 Jay 342 498 Kev 78 2500 Sam 420 50 Vic 10... (3 Replies)
Discussion started by: tech_frk
3 Replies

2. UNIX for Dummies Questions & Answers

Filter a particular string

Hi, I have a long log file. Out of which I want to filter particular occurrences where APC=4-033-0. Please help how it can be done. Input : +++ ELEMENT 12-05-27 23:15:06 CC 3482 #040185 > REPT APB TPE=C7NTL SM=22 OPC=4-003-7 APC=4-033-4 inaccessible END OF REPORT #040185 ++- ... (7 Replies)
Discussion started by: vanand420
7 Replies

3. Solaris

solaris IP filter ?

Hello, i have Solaris 10, is it possible to somehow limit remote access, via ssh for example , for only specific IP adresses , so when someone with IP that is not allowed can't connect via putty or something like that ? (2 Replies)
Discussion started by: tonijel
2 Replies

4. Linux

filter data

hi all, here is my question. i have the following data Block 1 a b c d e f g h i Block 2 j k l m n o p q r i need to grep all information from block 1 i.e 'a to i' (6 Replies)
Discussion started by: yprudent
6 Replies

5. Shell Programming and Scripting

How to filter Alphanumerics

Hi all, Can you please let me know how to achieve the below thing AAABBCC@#$W123 123@#$DFG<>. Output: AAABBCW123 123DFG i.e I want to filer only alphanumerics from the strings (4 Replies)
Discussion started by: marcus_kosaman
4 Replies

6. Solaris

logger + filter

Hi, I have an application log file and I am redirecting it to syslog ...| logger -p user.err Howver, the size redirected is too arge and I am seeking a way to filter what to redirect to syslog. any mean to do this, knowing that I do not want to decrease the log level of the app? ... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

7. UNIX for Dummies Questions & Answers

How to filter sentences??

Hi, I have few sentences here. $a1="Division of Hematology-Oncology, and Stem cell transplantation, Schneider Childrens Hospital, Albert Einstein College of Medicine, New Hyde Park, New York. "; $a2="Department of Cell Biology and Anatomy, College of Medicine, National Cheng Kung... (3 Replies)
Discussion started by: vanitham
3 Replies

8. Shell Programming and Scripting

File filter

Hi Everyone , have a nice i would need a little help on this i have file which contains blocks such as given below <hgsdp:msisdn=923228719047,loc; HLR SUBSCRIBER DATA SUBSCRIBER IDENTITY MSISDN IMSI STATE AUTHD 923228719047 410072110070614 CONNECTED ... (3 Replies)
Discussion started by: Dastard
3 Replies

9. UNIX for Dummies Questions & Answers

Filter using awk

Hi, I need to filter the output of a command and display omitting the first 6 lines and the last two lines..How can i do this using awk. command | awk ' NR > 7' will omitt the first 6 lines but dont know how to omit the last two lines.. can anyone help? (3 Replies)
Discussion started by: arun_st
3 Replies
Login or Register to Ask a Question