Using awk : picking specified columns


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Using awk : picking specified columns
# 1  
Old 07-21-2010
Using awk : picking specified columns

Hi,

I would like to get some specific fields from one long line.

My line looks like

CcnCDRFile0-8535123473201007170536_2010-07-20_17:06:02:,,9963387265,,,,,00720141432,,+0.310,+79.255,+78.945,,,,1492,,,,0,
CcnCDRFile1-8158123144201007114235_2010-07-20_12:07:31:2936022968,,9963387265,,,403,,00720104210,,+0.050,+103.305,+103.305,+2079.249,+2079.199, ,1492,,0,10,0,

i am using the command

grep 9963387265 *2010-07-20* | awk -F, '$6!= "403"'

getting the output as

CcnCDRFile0-8378123160201007114325_2010-07-20_11:54:32:,,9963387265,,,,,00720105520,,+0.000,+103.005,+103.005,,,,1492,,,,0,

but i would like 2 get the output as

CcnCDRFile0-8378123160201007114325_2010-07-20_11:54:32,9963387265,+0.000,+103.005,+103.005

Thanks in advance
Karthik
# 2  
Old 07-21-2010
You still do not use code tags and you have a thread already opened about this problem. Just because it is the next step in the problem there is no need to start a new thread for it. Use the old thread please, ty:
https://www.unix.com/unix-dummies-que...-coloumns.html

-Closed-
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to use "awk" to print columns from different files in separate columns?

Hi, I'm trying to copy and paste the sixth column from a bunch of files into a single file having each column pasted in separate columns (and not one after each other in just one column.) I tried this code but works only partially because it copied and pasted 50 rows of each column... (6 Replies)
Discussion started by: Frastra
6 Replies

2. Shell Programming and Scripting

Picking up last two specific files, for transfer

Hi I need to transfer files with csv extension from one server to another (all running solaris). But the files to be picked are in a directory that also has: /directory deposit_698.csv deposit_698.checksum deposit_699.csv deposit_699.checksum deposit_700.csv deposit_700.checksum... (15 Replies)
Discussion started by: fretagi
15 Replies

3. UNIX for Beginners Questions & Answers

Cherry picking with sed?

#!/bin/bash shuffle() { Deck=$(shuf -e {2,3,4,5,6,7,8,9,T,J,Q,K,A}{H,S,D,C}) } PH=(6H 9S KC) # playerhand CH=(JD 4D) # computerhand AC=2S # activecard shuffle echo $Deck I am unsure about how to proceed. I want to reshuffle a deck but without the cards in... (3 Replies)
Discussion started by: cogiz
3 Replies

4. Shell Programming and Scripting

Picking up files conditionally

Hi I have a scenario: I have a directory say DIR1 (no sub directories) and have few files in that directory as given below: app-cnd-imp-20150820.txt app-cxyzm-imp-20150820.txt app-petco-imp-20150820.txt app-mobility-imp-20150820.txt app-mobility-imp-20150821.txt... (7 Replies)
Discussion started by: Saanvi1
7 Replies

5. Shell Programming and Scripting

Picking values from a file.

Hi, I have a file which contains values in this format. abc cde fgh ijk lmn opq rst uvw The user will pass the required parameter from the command line. My requirement is that script should pick the values passed by the user and the next value in the next line. Like if the user... (10 Replies)
Discussion started by: arijitsaha
10 Replies

6. Shell Programming and Scripting

awk not picking up /PP SIZE/

for vgls in `lsvg` do lsvg $vgls | awk '/^VOLUME GROUP/ { printf "%s ", $3 } /PP SIZE/ { S=$6 } /TOTAL PPs/ { printf "%d ", $6*S/1024 } /FREE PPs/ { print $6*S/1024 } ' done This returns /TOTAL PPs/ and /FREE PPs/ fine, but not /PP SIZE/. Please advise. (11 Replies)
Discussion started by: Daniel Gate
11 Replies

7. Shell Programming and Scripting

Picking matching strings

I have a list of file names. However in some instances I might have a "-" at the beginning of the filename or an "=". For example I might have something like this set Lst = "file1 file2 file3 -file4 file5=" I want to pick up the ones having "-" at the beginning or "=" and store them in... (22 Replies)
Discussion started by: kristinu
22 Replies

8. Shell Programming and Scripting

need help on picking a right book

hi, I'm searching for a perfect book to learn awk programming, i started with sed&awk book, but i think this book might be outdated as it is written way back in 97 and also it doesn't have many examples. So, I thought of getting some advice from the experts here. Pls suggest me some books. ... (1 Reply)
Discussion started by: dvah
1 Replies

9. UNIX for Dummies Questions & Answers

Picking problem with printers

Hello to everybody i have problem the picking process falls and falls. I dont now what the picking process do i believe that is a print server on a data base i dont know where to look. Is a solaris 10 with korn sheell the process show this ps -ef | grep picking batch 18466 1 0... (5 Replies)
Discussion started by: enkei17
5 Replies
Login or Register to Ask a Question