Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Filtering some columns

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Filtering some columns
# 1  
Old 07-21-2010
Filtering some columns
Hi,

I would like to get some specific coloumns from from line.
My line looks
Code:
CcnCDRFile0-8380123164201007114335_2010-07-20_11:51:02:,,9963387265,,,,,00720105720,,-0.010,+101.785,+101.795,,,,1492,,,,0,
CcnCDRFile0-8389123182201007114404_2010-07-20_12:09:32:2936178350,,9963387265,,,403,,00720110835,,+0.150,+88.805,+88.805,+2078.149,+2077.999,,1492,,0,10,0,

Here i would like get the o/p from the line which has 403

The o/p should me
Code:
CcnCDRFile0-8389123182201007114404_2010-07-20_12:09:32:2936178350,9963387265,0.150,+88.805,+88.805,

Thanks in advance

Moderator's Comments:
Mod Comment Use code tags please, ty.
Last edited by zaxxon; 07-21-2010 at 05:54 AM..
# 2  
Old 07-21-2010
Code:
awk -F',' 'OFS="," {if ($6=="403") {print $1,$3,$10,$11,$12}}' data.file

This User Gave Thanks to dr.house For This Post:
appualex
# 3  
Old 07-21-2010
Code:
# cat infile
CcnCDRFile0-8380123164201007114335_2010-07-20_11:51:02:,,9963387265,,,,,00720105720,,-0.010,+101.785,+101.795,,,,1492,,,,0,
CcnCDRFile0-8389123182201007114404_2010-07-20_12:09:32:2936178350,,9963387265,,,403,,00720110835,,+0.150,+88.805,+88.805,+2078.149,+2077.999,,1492,,0,10,0,

Code:
# sed '$!d;s/^\(.*\),,\(.*\),,,.*,,+\(.*+.*+.*,\)+.*+.*/\1,\2,\3/' infile
CcnCDRFile0-8389123182201007114404_2010-07-20_12:09:32:2936178350,9963387265,0.150,+88.805,+88.805,

# 4  
Old 07-25-2010
Awk with column numbers to print.
Sed with Regex.

If you are not familiar with regex, use the awk method.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns satisfy the condition

HI All, I'm embedding SQL query in Script which gives following output: Assignee Group Total ABC Group1 17 PQR Group2 5 PQR Group3 6 XYZ Group1 10 XYZ Group3 5 I have saved the above output in a file. How do i sum up the contents of this output so as to get following output: ... (4 Replies)
Discussion started by: Khushbu
4 Replies

2. Shell Programming and Scripting

Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns

Hello All, I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns. So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies

3. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

4. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies

5. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

6. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies

7. Shell Programming and Scripting

Filtering first file columns based on second file column

Hi friends, I have one file like below. (.csv type) SNo,data1,data2 1,1,2 2,2,3 3,3,2 and another file like below. Exclude data1 where Exclude should be treated as column name in file2. I want the output shown below. SNo,data2 1,2 2,3 3,2 Where my data1 column got removed from... (2 Replies)
Discussion started by: ks_reddy
2 Replies

8. UNIX for Advanced & Expert Users

Help in Deleting columns and Renaming Mutliple columns in a .Csv File

Hi All, i have a .Csv file in the below format startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues 11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies

9. Shell Programming and Scripting

Filtering issues with multiple columns in a single file

Hi, I am new to unix and would greatly appreciate some help. I have a file containing multiple colums containing different sets of data e.g. File 1: John Ireland 27_December_69 Mary England 13_March_55 Mike France 02_June_80 I am currently using the awk... (10 Replies)
Discussion started by: crunchie
10 Replies

10. Shell Programming and Scripting

Single command for add 2 columns and remove 2 columns in unix/performance tuning

Hi all, I have created a script which adding two columns and removing two columns for all files. Filename: Cust_information_1200_201010.txt Source Data: "1","Cust information","123","106001","street","1-203 high street" "1","Cust information","124","105001","street","1-203 high street" ... (0 Replies)
Discussion started by: onesuri
0 Replies
Login or Register to Ask a Question